| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula not working
On Sheet 1 have the following data
Column A Column B Column C Column D NEWPORT (COMM) LIVERPOOL GATESHEAD (CAR) NEWPORT (COMM) NEWPORT (COMM) GATESHEAD (CAR) NEWPORT (COMM) NEWPORT (COMM) On Sheet 2 have the following formula to return the latest dealer. =IF(sheet1!$D$2=" ",sheet1!$C$2,IF(sheet1!$C$2=" ",sheet1!$B$2,IF(sheet1!$B$2=" ",sheet1!$A$2))). But my formula is not returning any values. Please help Row 2 should return Gateshead (CAR) Row 3, 4 and 5 should return Newport (Comm) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not working | Excel Worksheet Functions | |||
| Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) | |||
| Formula not working | Excel Worksheet Functions | |||
| Formula is not working | Excel Discussion (Misc queries) | |||
| Why isn't this formula working? | Excel Discussion (Misc queries) | |||
Threaded Mode
