PDA

View Full Version : Using HLookup



Tenspeed39355
03-06-2013, 09:49 AM
Good morning guys. Can HLookup return a string instead of just one cell?
If so what would the formula look like?
Would it look something like this?
=HLookup(A2,Sheet1!$A$2:$K$700, I have no idea where to go from here.
Thanks for any help.
Max

SamT
03-07-2013, 04:28 PM
AFAIK, the two Lookup functions can only return one cell. If you wanted to CONCATENATE the strings in two cells, you would have to
CONCATENATE(HLOOKUP(Whatever1), HLOOKUP(Whatever2))

Tenspeed39355
03-14-2013, 03:58 AM
Thanks for your reply. I have been out of town for several days and did
not reply. Again thanks
Max