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

"LLoyd" wrote:

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