| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF(ISERROR(MATCH - need value where match was found
I'm trying to work up a formula that will look at the value in a cell, find
it in a column on another sheet, and when found pull the value from the same row, different column where the match was found. Here's what I have so far: =IF(ISERROR(MATCH($B2,'[TIRs 11-06-03.xls]Sheet1'!$C$2:$C$12000,0)),0, ???? So if the match for the value in B2 was found in C100, the formula would pull the value from G100. Any assistance is appreciated. Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF ISERROR INDIRECT MATCH Formula Question??? | Excel Worksheet Functions | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| can lookup return err if no match found | Excel Worksheet Functions | |||
| Lookup returns message box when an exact match is not found | Excel Worksheet Functions | |||
![Ed[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
