specify range for a vlookup

[johncassell]

Hi There,

I have a VLOOKUP formula in my code but I need the ability for it to scan only part of the current row for the range..

Example:

vlookup("John",C1:IV1,3,false)

This would look along row 1 and give me the lookup value from cell E1.

But because I am running through each cell in column A I need it to be something like this..

vlookup("John", current row starting at column C up to IV, 3, false)

If someone understand that and can provide a solution I would be very grateful.

Thanks

John

[psumvp]

you need to use the hlookup() function to return values from rows. The functionality and syntax are the same

[psumvp]

maybe I am misunderstanding the question, post a sample please. If hlookup doesnt do it, offset will