IF and VLookup

[Ryan1974]

Hi.
I have 2 sheets.
Need to lookup the value from one in the other and if the values match then it needs to check for a second parameter in the first sheet and compare to second sheet and if all matches then display a value from the second sheet in the first.
So say the sheets are X and Y then I Need to grab Value 1 from X and find it in Y.
If value 1 is found in Y then code goes back to sheet X to find value 2 and find it in Y.
If value 2 is found then value 3 from sheet Y is displayed in sheet X.
Does that make sense?
No idea if VBA code might be easier therefore any input is welcome.
Thank you
Ryan

 

[bebo021999]

Worksheet formula: INDEX(MATCH or LOOKUP can do the job.
Fast answer needs visual help.
Try to attach a screenshot/XL2BB or share a sample file

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[jasonb75]

There are multiple methods that could be used for this but the descriptions are too ambiguous for us to provide a useful answer.

Where are values in sheet Y, are they in rows, columns, or matrices?

Are the values to return (value 3 in your description) numeric or text?

 

[Ryan1974]

Hi
thank you for your replies and sorry for the wait, took a while to do the test file.
Anyways, 2 sheets, Anonym 1 and 2, Instructions can be seen on 2nd sheet.
Hope that makes it more clear.
Values to return can be alphanumeric.

 

[jasonb75]

It is preferable that you use XL2BB to post any examples to the forum, when you post screen captures we have to try and remember your entire layout as we cannot view it and type a reply at the same time.

The basic principle of the formula that you will need is

=IFERROR(LOOKUP(2,1/('Anonym1'!$A$2:$A$10=$C2)/('Anonym1'!$E$2:$E$10=$D2),'Anonym1'!$D$2:$D$10),"No Match")

 

[Ryan1974]

Hi
@jasonb75 I tried to download it but system would not let me install, although i removed the protected view, it still had issues with the macro and nothing i tried worked. Conclusion: cannot download XL2BB.
Thx for the help
Br
Ryan

 

[jasonb75]

Did you try the formula that I suggested?