how can I do a lookup into another sheet?

[melawaisi]

how can I do a lookup into another sheet?
thanks

 

[Chip Pearson]

Try something like

=VLOOKUP(123,Sheet2!A1:B10,2,FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com