VLookup not working - missing entries or not returning correct values

  • Thread starter Thread starter dbush
  • Start date Start date
D

dbush

Dear all,

I am having 2 separate issues with some Vlookup functions in Excel.

1) The vlookup I have entered when dragged down to other cells does not appear to match to the array even though it has been locked in ($).

2) The vlookup doesn't pick up all of the options based the validation, drop down menu selection given, it does for some but not for all.

All help is gratefully received.
 
Hi,

Am Fri, 12 Dec 2014 06:43:25 -0800 (PST) schrieb
(e-mail address removed):
1) The vlookup I have entered when dragged down to other cells does not appear to match to the array even though it has been locked in ($).

2) The vlookup doesn't pick up all of the options based the validation, drop down menu selection given, it does for some but not for all.
Click to expand...

check the formats of your data.
Post your formula and show as examples of your data.
Or upload your workbook and post the link.


Regards
Claus B.
 
Back
Top