Lookup a criteria from another sheet

  • Thread starter Thread starter LLoyd
  • Start date Start date
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
 
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
 
Back
Top