| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| vlookup retunrning a match, when not a match... | Excel Worksheet Functions | |||
| second or third match in vlookup() or Match() | Excel Worksheet Functions | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Linear Mode
