| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for searching spreadsheet
Hi,
I am using the following formula to search a sheet for data and then return it to a summary sheet in the same workbook. =IF(ISERROR(VLOOKUP($A5,FGU!$A$2:$H$2742,4,FALSE)) ," ",VLOOKUP($A5,FGU!$A$2:$H$2742,4,FALSE)) $A5 is the reference in the summary sheet and is a code of a product e.g. AP282003. My problem is that in the sheet I am searching the products can have a letter at the end e.g. AP282003M or AP282003MH or just be AP282003. How can I modify the code to pick up the all 3 items? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| Is there a formula for searching for any one of a list of strings? | Excel Worksheet Functions | |||
| Formula for searching for a text string | Excel Discussion (Misc queries) | |||
| Searching a spreadsheet | Excel Discussion (Misc queries) | |||
| extracting data from a spreadsheet by searching on columns | New Users to Excel | |||
Threaded Mode
