IF, VLOOKUP or MATCH?

T

Tony7659

I have a spreadsheet with 6 tabs, each tab has 3 sets of data. I am trying to
find a number in each of the tabs and if found, perform an operation. The
number needs to be searched in 3 columns per tab so I would exceed the limit
of nested IFs. Any ideas? Thanks

Tony.
 

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

OR AND VLOOKUP 10
Vlookup or similar 7
MATCH does not equal 2
Lookup or Index/Match 1
Lookup or If, then Question 1
Vlookup or Index/Match 2
Using Tab Number as VLOOKUP? 3
Excel Excel: Match, Index and subtract across 2 columns and 2 tabs 2

Top