If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
lookup for double column
Hi
I think this is very easy question but couldn't do it myself below sample. std sheet is: a b c d e f g h kk rr 75 tt 15 ss mm 17 My main sheet is : a b kk tt rr ss mm I tried formula on my main sheet in b4=VLOOKUP(A4;std!A:S;8;FALSE) for looking up "std sheet" a or b column and get value for kk:75; tt:15 ;rr:75 ;ss:17 and mm:17. This formula is working for a column ,not lookup value from b column.... I feel offset and match with vlookup but didn't figured out. Thanks in advance Ibo |
#2
|
|||
|
|||
lookup for double column
"ibo" wrote in message
... Hi I think this is very easy question but couldn't do it myself below sample. std sheet is: a b c d e f g h kk rr 75 tt 15 ss mm 17 My main sheet is : a b kk tt rr ss mm I tried formula on my main sheet in b4=VLOOKUP(A4;std!A:S;8;FALSE) for looking up "std sheet" a or b column and get value for kk:75; tt:15 ;rr:75 ;ss:17 and mm:17. This formula is working for a column ,not lookup value from b column.... I feel offset and match with vlookup but didn't figured out. Thanks in advance Ibo VLOOKUP always looks up a value in the FIRST column of the lookup range. You could try something along these lines: =IF(ISNA(VLOOKUP(A4;std!A:S;8;FALSE)),VLOOKUP(A4;s td!B:S;7;FALSE),VLOOKUP(A4 ;std!A:S;8;FALSE)) |
#3
|
|||
|
|||
lookup for double column
Thank you Anon You are great....... "Anon" none wrote in message ... "ibo" wrote in message ... Hi I think this is very easy question but couldn't do it myself below sample. std sheet is: a b c d e f g h kk rr 75 tt 15 ss mm 17 My main sheet is : a b kk tt rr ss mm I tried formula on my main sheet in b4=VLOOKUP(A4;std!A:S;8;FALSE) for looking up "std sheet" a or b column and get value for kk:75; tt:15 ;rr:75 ;ss:17 and mm:17. This formula is working for a column ,not lookup value from b column.... I feel offset and match with vlookup but didn't figured out. Thanks in advance Ibo VLOOKUP always looks up a value in the FIRST column of the lookup range. You could try something along these lines: =IF(ISNA(VLOOKUP(A4;std!A:S;8;FALSE)),VLOOKUP(A4;s td!B:S;7;FALSE),VLOOKUP(A4 ;std!A:S;8;FALSE)) |
Thread Tools | |
Display Modes | |
|
|