| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| second or third match in vlookup() or Match() | Excel Worksheet Functions | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Linear Mode
