Hi all,
I have a formula that is not quite capturing what I need it to....
Formula is:
but since I didn't creat the formula, I do not have the knowledge enough to tweak it. It currently returns part of a cells contents, summed (a number value); however, I need it to return the entire contents of the cell....
Please Login or Register to view this content.
Example:
Currently returns: 10
Want it to return: 10 OT L1P
Spreadsheet attached - thanks
Last edited by Greed; 10-25-2011 at 12:59 PM. Reason: Solved
How about =HLOOKUP("*" & $R2 & "*",$B$4:$H$4,1,FALSE)
Well, that does return the contents of the cell, but if there are no matching cells it returns #N/A error and I don't want that since the majority of the cells will not have a matching value....any other ideas?
thanks
In Excel 2003:
=IF(ISERROR(HLOOKUP("*" & $R2 & "*",$B$4:$H$4,1,FALSE)), "", HLOOKUP("*" & $R2 & "*",$B$4:$H$4,1,FALSE))
In Excel 2007+:
=IFERROR(HLOOKUP("*" & $R2 & "*",$B$4:$H$4,1,FALSE), "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Super - thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks