![]() |
|
#1
|
||||
|
||||
![]() Try: =IF(E5<>"","EE",IF(F5<>"","LL",IF(G5<>"","BP",IF(H 5<>"",504,IF(I5<>"","D","")))))
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
Yes!!!! Thanks a lot!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find text within cell and return column and row title next to the name on a new sheet. | tanyabowring@live.co.uk | Excel Programming | 2 | 03-26-2015 01:48 AM |
How to return the first cell in a row? | dapeamel | Excel | 0 | 02-26-2015 12:56 AM |
![]() |
mariur89 | Excel | 4 | 12-14-2014 01:33 AM |
Would like to return a row rather than a cell using VLookup | canajun | Excel | 7 | 12-10-2014 01:03 PM |
![]() |
zks | Excel | 6 | 01-22-2012 10:24 PM |