Match data to a range if a match is found perform lookup, if no match found repeat.

[madmax76]

I am using the formula below and it works great but.... I want to check several worksheets within the same workbook for a match not just one and once a match is found I then want to perform a lookup/index in a different workbook. The workbook the lookup is performed on varies depending on which worksheet the match is found in.

Please Login or Register  to view this content.

The below whilst it does not work I think it explains what I want to do! excel accepts the formula but I get "#VALUE!" as a result not sure where am going wrong but sure its something simple!!

Please Login or Register  to view this content.

Hope someone can help me close this one down.

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )