Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
85
Views
Topic starter
Hi
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:
=VLOOKUP(A1:A353,'Lookup Test'!A1:A3015,4,FALSE)
Its bringing back #N/A results on all lines.
I have sorted in ascending.
Any ideas?
Thanks
Posted : 29/06/2020 8:00 pm
Hi Liesl,
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.
Regards
Phil
Posted : 29/06/2020 8:21 pm
