| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup 3 columns all return same
i have this formula in 3 columns but w different tabs in the spreadsheet
=IF(VLOOKUP(A5,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,2),1,"") i.e. a column looking in the "shares" tab then "stocks" then "model", however they all return a value of 1 even though A5 will only be found in one of them. i am not sure what i have done wrong. thanks anyone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup return 0 when cell is blank | Excel Worksheet Functions | |||
| Return alternate value if VLookup can't find match | Excel Worksheet Functions | |||
| In Excl how can I return letters to the columns I now have numbers | Excel Discussion (Misc queries) | |||
| Vlookup - return row no. instead of value | Excel Discussion (Misc queries) | |||
| vlookup for multiple columns | Excel Worksheet Functions | |||
Threaded Mode
