June 29, 2020
I am new to Vlookup (so please be gentle hahaha)
I have a workbook with two worksheets. I am trying to pull pricing data from the second worksheet to the first.
I have used the Formula Wizard (if thats what its called) and have come up with the following:
Its bringing back #N/A results on all lines.
I have sorted in ascending.
October 5, 2010
The first thing that pops out is that you've asked VLOOKUP to return the 4th column but your data is only 1 column wide.
Also, I presume you have dynamic arrays as you are looking up multiple values?
It's always best if you supply a workbook with data when you ask a question so we can see what you are working with.