LOOKUP TABLE ON DIFFERENT WORKSHEET

[G-fer]

Hi Team ...

I need to use vlookup in a cell, (call it A1), on sheet1 referencing a range on sheet2 (call it B10:C20).

Cell A1 sheet 1

=vlookup(something,B10:C20 on sheet2,2,False)

I've tried sticking in sheet2! and a couple of other things, but I can't seem to get it to work.

Any ideas?

Regards.... G-fer.

 

[stanleydgromjr]

Try this:
=VLOOKUP(A1,Sheet2!B10:C20,2,FALSE)


Have a great day,
Stan

 

[G-fer]

Thanks Stan,

That fixed it.

You have a great day too.

G-fer.