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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup, indexing, oh my.... 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
lookup/match mult values 3
Triple IF? 2
lookup then concatenate 2
sumproduct with text 1
Count columns that meet criterias 3
copying_data_using_FillHandle 1

Back
Top