lookup for double column

[ibo]

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

 

[Anon]

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;std!B:S;7;FALSE),VLOOKUP(A4
;std!A:S;8;FALSE))

 

[ibo]

Thank you Anon
You are great.......

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;std!B:S;7;FALSE),VLOOKUP(A4
;std!A:S;8;FALSE))