| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Modification Help
Hello,
I need to modify the lookup formula below because what it now looks for has the letters IM in front of the munbers. Example IM1780 where before they were straight numbers. Example 4160048 I would like to say If (H3779,PSWRDREQ,2) is equal to IM....then only give me the numbers to the right of the IM. Example 1780.... Can you plese help? The formula as it is now is: =IF(ISERROR(VLOOKUP(H3779,PSWRDREQ,2,FALSE)),"",VL OOKUP(H3779,PSWRDREQ,2,FALSE)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
