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