ExcelBanter - IF, VLOOKUP or MATCH?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF, VLOOKUP or MATCH? (https://www.excelbanter.com/excel-discussion-misc-queries/231954-if-vlookup-match.html)

Tony7659

IF, VLOOKUP or MATCH?

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.

Manoj Rai

IF, VLOOKUP or MATCH?

thanks

"Tony7659" wrote:

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.

All times are GMT +1. The time now is 03:50 AM.