Desperate Lookup Help Required

[Jason]

I need a lifesaver, I cannot use the vlookup for this
because of the way it is set up. I need to be able to use
the hlookup combined with a vlookup. I want to be able to
lookup a number from another worksheet, but then I also
want to be able to return the value which is one column to
the right, so in theory I need a formula that can lookup
the value in the column first, and then look one row to
the right to give me the value in the next column.
Any help gratefully received.
Thanks in advance!

 

[Frank Kabel]

Hi Jason
that is exactly what lookup is for:
try the following (assumption column A is your lookup column and column
B stores the return values):
=VLOOKUP(your_search_criteria,'sheet2'!$A$1:$B$999,2,FALSE)
the 2 as third parameter indicates that you want the second column of
your matrix for the return value.

HTH
Frank

 

[Bob Phillips]

Jason ,

This is exactly what VLOOKUP does. What are you getting?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Randall Roberts]

If your data isnt sorted by the column you are looking up you are
better off to use

Index and Match