vlookup help needed

[Steven J]

I am using the following syntax.

=VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)

I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
contents of the relevant row cell in 'MIS!B4:B1000'

Can someone tell me what I have wrong please

thanks
S

 

[Steven J]

Sorry, my syntax in above was wrong. Iam using:

=VLOOKUP('MIS'!A4:A1000,'MIS'!B4:B1000,A59,FALSE)

 

[Niek Otten]

=VLOOKUP(A59,MIS!A4:B1000,2,FALSE)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel