| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Formula
My bad. The formula works fine. Thank you
"Byron720" wrote: This formula might work but I always get the "Part Not Found Anywhere". I changed the ranges to A:A in both cases and still. I also checked the format of the part #'s in both tables. "Luke M" wrote: If the part you're looking up is in A2, and your lists are in column B of each sheet, something like =IF(ISNUMBER(MATCH(A2,'Returnable'!B2:B100,0)),"Re turnable",IF(ISNUMBER(MATCH(A2,'Not Returnable'!B2:B100,0)),"Not Returnable","Part not found anywhere") would work for you. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Byron720" wrote: I have a file with two sheets: Returnable and Not Returnable. I need a formula on a third sheet that tells me if a part is returnable or not based on the lists. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Formula | Excel Discussion (Misc queries) | |||
| Help with a Lookup formula ? | Excel Worksheet Functions | |||
| Lookup formula? | Excel Discussion (Misc queries) | |||
| Formula help (Lookup) | Excel Discussion (Misc queries) | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Hybrid Mode
