Referencing multiple items

**Richard Buttrey** · 08-26-2008, 04:27 PM

Hi, and welcome to the forum.

Yes, the technique I generally use is to create a helper column, and use this to concatenate the values from the other three columns, i.e. =A1&B1&C1, then use this as the subject of the VLOOKUP() - or indeed =MATCH() function.

HTH

**msbaath** · 08-26-2008, 05:47 PM

I never thought of that. Thank you!

**Richard Buttrey** · 08-26-2008, 06:31 PM

Originally Posted by msbaath

I never thought of that. Thank you!

Hi,

That's why we're here. Glad to be of help.

Rgds

**msbaath** · 08-28-2008, 05:08 PM

This method works fine save when one of the columns contains time. Do you know why it would do that?

**Richard Buttrey** · 08-28-2008, 06:53 PM

Hi,

It should work with any value. A Time is just another value, specifically a decimal of 24 hours, so you should see for instance 0.5 for 12:00 noon. So concatenating a Time and a Name you should see "0.5Bill"

Why do you think it's not working, or are you saying that you have a volatile =Time(hh,mm,ss) function which keeps changing?

Rgds

**msbaath** · 09-02-2008, 03:52 PM

I have time in the format "hh:mm:ss" and the two times that I am trying to correlate differ by some milliseconds.. which I think is due to rounding. For some reason I can't get them to match, I used function round but no use. The method you mentioned works perfect.. I am just trying to figure out how it would work for this scenario. Thank you for all your help.