cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SOLVED

#ref in vlookup

MRAfshar3000
Occasional Contributor

‎Apr 28 2022 01:08 PM

‎Apr 28 2022 01:08 PM

#ref in vlookup

MRAfshar3000_0-1651176019348.pngMRAfshar3000_1-1651176026699.png

how do i fix the error ?

Labels:
105 Views
0 Likes
1 Reply
Reply
1 Reply
best response confirmed by MRAfshar3000 (Occasional Contributor)
Peter Bartholomew

‎Apr 28 2022 01:34 PM

‎Apr 28 2022 01:34 PM

Solution

Re: #ref in vlookup

@MRAfshar3000 

The third parameter of VLOOKUP is a number identifying the column to return. If you have it XLOOKUP might suit you better.

0 Likes
Reply