| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match
I can't understand why my lookup formula can't find the SqRect_LBL values.
The cell in E100 should read SqTube. What am I doing wrong? =IF(ISNA(MATCH(C100,'bt_rev_10-10-07.xls'!SqRect_LBL,0)),"BOGUS","SqTube") Cell C100 = 4x4x.375. The tables are in a workbook named TBL_PIPE. The SqRect_LBL is found at =TBL_PIPE!$AE$4:$AE$520. The SqRect_TBL is found at =TBL_PIPE!$AE$4:$AH$520. I checked the text in the cells and the only difference I could find were the column widths are different and the lookup LBL had a 0 in front of .375. I removed the 0 but no effect. Cell E100 and the matching cell in my lookup table are the same length. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions | |||
Threaded Mode
