| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help--Vlookup?
I need help wrinting a formula for the below.
Sheet 1 A1=Style Number B1=Size (text value) C1=part number (formula result) Sheet2 contains the data. There are multiple entries of the style number (A1) on sheet 2. The size is actually part of the TEXT description of that style. I need the formula to give me the part number of that Size in that Style number. Is there a way to write the formula to look for the Style number, then look in that description for the text value and when they match, give me the part number 1 column over? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine a VLOOKUP formula and a NETWORKDAYS formula? | Excel Worksheet Functions | |||
| Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
| convert vlookup formula to link formula | Excel Worksheet Functions | |||
| VLOOKUP best formula to use? | Excel Discussion (Misc queries) | |||
| Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
Threaded Mode
