Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
dEAR aLL pLEASE hELP mE
In sheet1 Column C2 i have a formula which compare A2 value in sheet1 with (B9) value in CrewList, if it is true return the value in C9. =IF(ISNA(VLOOKUP(A2,CrewList!$B$9:$C$33,2,0)),"",V LOOKUP(A2,CrewList!$B$9:$C$33,2,0)) I just want to change instead of B9 to look up at K9 I changed the formula something like this and it is not working. =IF(ISNA(VLOOKUP(A2,CrewList!$k$9:$C$33,2,0)),"",V LOOKUP(A2,CrewList!$k$9:$C$33,2,0)) Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If and Vlookup formula | Excel Discussion (Misc queries) | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
vlookup formula | Excel Discussion (Misc queries) |