Matching values from Sheet1, returning value from Sheet2

Mar 8th, 2002, 12:52 AM

I need a formula where on Sheet1 cells A10 and K3 have a value entered. I would like to look up the matching value on Sheet2, column A & B, then return the value from Sheet2 column C to Sheet1 cell D10.

Appreciate any feedback.

Derek · Mar 8th, 2002, 01:34 AM

Hi
I assume you mean this:
Look down column A in sheet2 to find the value equal to A10 (where the value next to it in column B is equal to K3), then return the value in column C.
You could try this formula in Sheet1 D10
=INDIRECT("Sheet2!C"&MATCH(A10&K3,Sheet2!D:D,0))

This requires use of a hidden column in Sheet2. I have used column D:D
Insert this formula in D1 and scroll down =A1&B1

Hope this helps
Regards
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 12:52 AM	#1
Guest Posts: n/a	I need a formula where on Sheet1 cells A10 and K3 have a value entered. I would like to look up the matching value on Sheet2, column A & B, then return the value from Sheet2 column C to Sheet1 cell D10. Appreciate any feedback.

Mar 8th, 2002, 01:34 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi I assume you mean this: Look down column A in sheet2 to find the value equal to A10 (where the value next to it in column B is equal to K3), then return the value in column C. You could try this formula in Sheet1 D10 =INDIRECT("Sheet2!C"&MATCH(A10&K3,Sheet2!D:D,0)) This requires use of a hidden column in Sheet2. I have used column D:D Insert this formula in D1 and scroll down =A1&B1 Hope this helps Regards Derek