Row and Column lookup and fill value

Prascena

New Member
Joined
Nov 2, 2015
Messages
7
Hi,

1st sheet of my excel:

35582ac35582de38920aa38032f
332
122
21
32

<tbody>
</tbody>

2nd sheet of my excel:

IR NoAssembly NoQty
0435582ac2
12238920aa3
12238852de1
3238032f2
33235582ac2
33238852de3

<tbody>
</tbody>

Required Output:

35582ac35582de38920aa38032f
3322300
1220130
210000
320002

<tbody>
</tbody>

Is it possible to automate this?

Please help with the formula.

Thank you in advance.

Regards,
Prasanna.A
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Like this:

=SUMIFS(Sheet2!$C$1:$C$100,Sheet2!$A$1:$A$100,$A2,Sheet2!$B$1:$B$100,B$1)

You need to make sure your codes are identical though. 38852de is not 35582de
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top