Match + VLOOKUP
 

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

Match + VLOOKUP
 

One way...

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

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
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