Return the value of a cell

		Microsoft Office Forums > Microsoft Excel > Excel
Return the value of a cell

06-08-2015, 08:39 PM

macropod

Windows 7 64bit Return the value of a cell

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Try:
=IF(E5<>"","EE",IF(F5<>"","LL",IF(G5<>"","BP",IF(H 5<>"",504,IF(I5<>"","D","")))))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
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
Search for multiple texts in cell, return specific text	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
Return cuurent time when another cell is updated	zks	Excel	6	01-22-2012 10:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 PM.