Linking sheet - Formula Match Exact or select next row and cell

L

Lil Knight

I am trying to set up a formula linking three sheets ( later books) pulling
information from one sheet only if it matches a second sheet, otherwise I
need it to check the next row and cell until it comes up with a match, then
print the information in a cell?
So far:
=IF(ISNA(MATCH(Sheet3!B2,Sheet3!B:B,0)),"",INDEX(Sheet3!A:A,MATCH(Sheet3!B2,Sheet2!B:B,0)))

It will not check further rows if sheet2!B2 does not match.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula fill series? 1
Match Copy/Paste Macro almost there 0
IF Statement Problem 4
Create if partial match then copy and paste data from one cell to another 1
Complex match 1
How to do an IF statement that copy data based on a partial match 0
Compare formula 2
Conditional Indexing 2

Top