LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
dbl
 
Posts: n/a
Default If function using Index

Hi I am using the following formula in sheet Data Entry cell B14
=IF(INDEX(Sheet1!C:C,MATCH(B7,Sheet1!A:A,0),1)="AS A","NO","YES")
which works fine. But I need to add more to it as follows:

If the above also ="GIG", "NO","YES"
Plus if cell B33="ASA123456","YES","YES"

Cell B14 & B33 are on a sheet called Data Entry all the other info comes
from Sheet1

How do I add the above into my formula?

Bob


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting result of Index function ExcelFred Excel Worksheet Functions 5 July 26th 05 01:34 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Naming column in Index Function mlkpied Excel Worksheet Functions 3 December 7th 04 12:20 AM
Variable values in Index function mlkpied Excel Worksheet Functions 6 December 6th 04 11:38 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"