Look up value in one sheet and post relating value to another sheet

UNISTUDENT

New Member
Hi Guys, I'm new to this forum, I had a quick look and couldn't find an answer to my problem so if you can help or link me to another thread which answers this then that would be great.

Basically what I want is for one sheet to read another sheet and depending on what that is post a response which is then a result. The basic formula I am working with is

=IF(Sheet3!C2=Sheet1!A2, Sheet1!D2)

However, in the above example there are 52 different inputs all with a different result which is correlated through sheet1. Is there a way that I can get excel to read the list I have produced in sheet1 to give me the output that corresponds to this? The only alternative I could think of would be to write:

=IF(Sheet3!C2=Sheet1!A2, Sheet1!D2, IF(Sheet!3C2=Sheet1!A3, Sheet1!D3, IF(....)

For 52 different IFs which doesn't seem at all efficient.
Is there an iteration or list function that would be suitable?

Thanks for your help

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Code:
``=VLOOKUP(Sheet3!C2,Sheet1!A:D,4,FALSE)``
Hope this helps,

Chris.

Code:
``=VLOOKUP(Sheet3!C2,Sheet1!A:D,4,FALSE)``
Hope this helps,

Chris.

Thanks Chris, I got this to work nicely. A much simpler way!

Yw.

Replies
1
Views
175
Replies
3
Views
140
Replies
15
Views
307
Replies
11
Views
734
Replies
7
Views
316

1,206,711
Messages
6,074,470
Members
446,071
Latest member
gaborfreeman

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?

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

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