Vlookups not working


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.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top