Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try to trim your text. basically or sent me the sheet.
Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array VLOOKUPs take 6 times longer than worksheet range VLOOKUPs | Excel Programming | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Working with vlookups | Excel Discussion (Misc queries) | |||
VLOOKUPS | Excel Programming | |||
Vlookups | Excel Programming |