Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP NOT RETURNING EXPECTED DATA
I am trying to search data from between various sheets of a single workbook
but my results are not quite what I expected. I have a single workbook in which I am looking for different data on seperate sheets but which will display data that initially originates from one sheet which is collected by another and then displayed on a third. The workbook is a data base of league players, on my first sheet tab I have all of their contact details typed in, I then use this to transfer their details onto other sheets using their reference No. and the VLOOKUP option. My cell contains the calc =IF(A4<"",VLOOKUP(A4,'PREMIERSHIP - NR'!$A$4:$O$203,6,FALSE),"") where 'PREMIERSHIP - NR' is the name of the sheet I am searching from - !$A$4:$O$203 is the range from that sheet and 6 (which is a cell holding a written name) is the column holding the detail I want to find. The calc works well and finds and displays the correct data when there is something actually written or displlayed in it, but my difficulty is that in many instances there is no data displayed for it to find €“ i.e. it is a blank cell but returns as #N/A in some instances or 0 (zero) in others and this has confused the hell out of me. What I want to try to do is return the word if it is written in the target cell (which it does do) or absolutely nothing if the target cell contains nothing to report which in some instances it does not which is when it will return the zero but in others there is a calc which only displays if filled by other criteria being fullfiled and it is in this instance when I get the #N/A returned. Could anyone please help me out with a solution. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct not returning expected results | Excel Worksheet Functions | |||
Lookup returning one more than expected | Excel Worksheet Functions | |||
Using sum(1/countif....) not returning expected result | Excel Worksheet Functions | |||
Nested "if" not returning expected value | Excel Worksheet Functions | |||
Returning expected dates | Excel Worksheet Functions |