Match + VLOOKUP

[Mike]

Hi,

Say you are in sheetA searching for a value in cell g3 (still in
sheetA) that might exist in column D of sheetB. If found, return the
value that exist in column W of sheetB

I thought of using "Match" with "VLOOKUP" but somehow it is not
working!

Any smarter way to do it?

Thanks,
Mike

 

[T. Valko]

One way...

=INDEX(Sheet2!W1:W100,MATCH(G3,Sheet2!D1100,0))