# Find a certain value in a column and check that row for &quo

#### Remaniak

##### New Member
Hi All,

I would like to do the following:

I am in sheet "Analysis", and I have in cell C23 the value "lot 1".

What I need, is a formula in cell D23 that checks in sheet "data" (range \$B\$9:\$AA\$81) in column B for the value of cell C23, namely "lot 1". If it find that value, it has to check within that row for the value "1". If it finds the value "1", in say column G and row 40, it should provide the value of two columns back, thus column D row 40.

Does anyone have a none VB solution for this?

Thanks a lot!!!

Remaniak

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
=INDEX(\$C\$9:\$AA\$81,MATCH("lot 1",\$B\$9:\$B\$81,0),MATCH(1,INDEX(\$C\$9:\$AA\$81,MATCH("lot 1",\$B\$9:\$B\$81,0),0),0)-2)

Great Once Again!

Thanks a bunch!

Michiel

Replies
4
Views
186
Replies
1
Views
174
Replies
0
Views
168
Replies
3
Views
255
Replies
18
Views
446

1,216,487
Messages
6,130,944
Members
449,608
Latest member
jacobmudombe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back