lookup function, I need hlep
 

I am wanting to use the lookup function to insert a particular value from a
list in another worksheet in the same workbook eg.

If data in A1 & B1 are present then lookup the other worksheet to find both
data values from A1 & B1 and then return the value in column C of the 2nd
worksheet

lookup function, I need hlep
 

It's not real clear what you want. Here's my best guess:

Enter this array formula** in sheet1 C1:

=INDEX(Sheet2!C1:C10,MATCH(1,(Sheet2!A1:A10=A1)*(S heet2!B1:B10=B1),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Northo111" wrote in message
...
I am wanting to use the lookup function to insert a particular value from a
list in another worksheet in the same workbook eg.

If data in A1 & B1 are present then lookup the other worksheet to find
both
data values from A1 & B1 and then return the value in column C of the 2nd
worksheet

lookup function, I need hlep
 

Thanks T.Valko

The array formula was exactly what I was looking for

Cheers
Northo111


"Northo111" wrote:

I am wanting to use the lookup function to insert a particular value from a
list in another worksheet in the same workbook eg.

If data in A1 & B1 are present then lookup the other worksheet to find both
data values from A1 & B1 and then return the value in column C of the 2nd
worksheet

lookup function, I need hlep
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Northo111" wrote in message
...
Thanks T.Valko

The array formula was exactly what I was looking for

Cheers
Northo111


"Northo111" wrote:

I am wanting to use the lookup function to insert a particular value from
a
list in another worksheet in the same workbook eg.

If data in A1 & B1 are present then lookup the other worksheet to find
both
data values from A1 & B1 and then return the value in column C of the 2nd
worksheet

lookup function, I need hlep
 

I have a workbook with 3 sheets.

IMM
WELDERS
SAFETY

All three of the sheets have the same columns:

A B C D E
F
Date Created - Equip. # - From - Description - Date Completed - Priority

I need to return all values from the first two sheets that have in the
Equip. # column 'G958' and the rest of the data on that row to the Safety
sheet.