U
Udayan
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)),"",VLOOKUP(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)),"",VLOOKUP(A2,CrewList!$k$9:$C$33,2,0))
Please help
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)),"",VLOOKUP(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)),"",VLOOKUP(A2,CrewList!$k$9:$C$33,2,0))
Please help