Give us one specific problem to solve. The 3 sheets in I3 lost me.

"Be18" wrote:

Thank you for your responses!!! However this doesn't seem to work! Maybe
because there's no mention of sheet 3!! Am I trying to do too much maybe?

"Barb Reinhardt" wrote:

Actually, I think you want HLOOKUP.

=HLOOKUP(I3,'Sheet2!G2:J2,1,FALSE)

HTH,
Barb Reinhardt

"Be18" wrote:

Hi

I am trying to figure out if I can use VLOOKUP to check a range of cells. I
am probably using the wrong fuction and there is much simpler way of doing
this -
I have 3 sheets in I3 on sheet 1 I want to put in a formula that checks if
the values on sheet 2 G2 to J2 to match any of the values on sheet 3 A13 to
A20 (i've called the table array masters!) and if they do I want them to put
this same value into I3. I hope that makes sense! Can anyone please tell me
if this is at all possible and if so how I do it?

Thank you very much