Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLOOKUP formula combined together
{=IF(K8=AA11:AA21,VLOOKUP(K8,'Regular Assessment Table'!
I2:J12,2,FALSE))} The above formula is looking up a K8 text content and returning a vlookup value from a table. Part of the text I enter is "104(a) Citation" and the formula return the correct value. But when I enter "104(d)(1) Citation" the formula returns FALSE. For the life of me I cannot determine why this is happening. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with IF and VLOOKUP combined | Excel Worksheet Functions | |||
VLOOKUP combined with AND | Excel Discussion (Misc queries) | |||
vlookup combined with AND-function | Excel Worksheet Functions | |||
vlookup and match combined? | Excel Worksheet Functions | |||
vlookup / len function combined | Excel Discussion (Misc queries) |