Incorrect Argument Set error when using Vlookup to reference another sheet.

DLanca

I am using a Vlookup to use a row id in sheet A to lookup the corresponding row id in sheet B and return the value in the status column - the syntax looks correct to me but I am getting an Incorrect Argument Set error.

This is the syntax I am using:

=VLOOKUP([Row ID]@row, {Cutover Tasks Range - Row ID}, 6, false)

Can you tell me what is wrong here?

Thanks

Mark.poole

Are all the Columns in the ref right next to each other. This requirement is why i prefer using Index Match

=Index({Status Ref},Match([Row ID]@row,{Row ID Ref},0))

DLanca

Hello,

Thanks for the info. I have tried the using Index Match as you suggested and am getting an #INVALID REF error on this:

=INDEX({Range - Row ID}, MATCH([Row ID]@row, {Row ID Ref}, 6))

Any ideas