Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value from other spreadsheet
i have this formula
=IF(COUNTIF(Path/Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path/Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path/Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) i want S, FI or PI to be returned depending on where the value in A4 is found, but i get a value message. Please help. thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
compare two spreadsheets and return a value | Excel Worksheet Functions | |||
Copy From One Spreadsheet To Another Spreadsheet | Excel Discussion (Misc queries) | |||
Displaying contents of cell on different spreadsheet | Excel Discussion (Misc queries) | |||
Huge problem with "if" formula's | Excel Discussion (Misc queries) |