lookup function, I need hlep

[Northo111]

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

 

[T. Valko]

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)*(Sheet2!B1:B10=B1),0))

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

 

[Northo111]

Thanks T.Valko

The array formula was exactly what I was looking for

Cheers
Northo111

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[wgage]

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.