| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
i want the cell to check 3 worksheets from another workbook and return S, FI
or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup function return all values | Excel Worksheet Functions | |||
| Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| Want VLookup to Return the row above | Excel Worksheet Functions | |||
| Vlookup of an if statement return | Excel Worksheet Functions | |||
Threaded Mode
