Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup a criteria from another sheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup a criteria from another sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
Lookup using more than one criteria | Excel Worksheet Functions | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
how to use lookup a value by date for criteria in Excel sheet | Excel Worksheet Functions | |||
lookup with 2 criteria | Excel Discussion (Misc queries) |