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

[UNISTUDENT]

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

 

[Chris Mack]

=VLOOKUP(Sheet3!C2,Sheet1!A:D,4,FALSE)

Hope this helps,

Chris.

 

[UNISTUDENT]

=VLOOKUP(Sheet3!C2,Sheet1!A:D,4,FALSE)

Hope this helps,

Chris.

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

 

[Chris Mack]

Yw.