Lookup a criteria from another sheet

L

LLoyd

Good Day

I what to lookup a crieria in col A and it gives me what is in col B.

Col A Col B
Repair & Maintenance 13,500.00

Thanks
 
W

WLMPilot

First, please post the complete question in the text part. You have part of
the question ("from another sheet") in SUBJECT and the other part, which says
nothing about another sheet, in the text.

=LOOKUP("Repair & Maintenance ",Sheet1!A1:A30,Sheet1!B1:B30)

Les
 
Top