vlookup vs Index match function

**6StringJazzer** · 09-19-2013, 10:24 PM

The formula you are showing does not match your description. Your formula will return a value from column C of Sheet1. If you want an answer from column B then you want

Formula:

=VLOOKUP(A2,'Sheet 1'!A:B,2,FALSE)

**ladyv** · 09-19-2013, 10:52 PM

Hi 6StringJazzer,

Thank you for your response and correction (Yes, you're right and I have that same vlookup function in place).

I am after an alternative function (Index (match)) that could produce a better result.