#1   Report Post  
Old August 11th 17, 09:57 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: May 2015
Posts: 8
Default Two condition IF

Using Excel 2007, I’m trying to use an If statement to return “Y” or “” against two conditions.
In tab titled “PostMove”, I would like a formula which looks at B6 to get 6338016, then looks at I4 to get SR360. Using Vlookup perhaps look in the tab CD_Dump to return a Y because the two criteria match was found (6338016 & SR360). In J6, the formula would return “” because SR374 is not one of the matches for 6338016. I would like to copy this formula across rows J to W.

Col B Col I Col J etc to Col W
Row OEM ID SR360 SR374
6 6338016

Tab titled “CD_Dump” with 93945 rows
Col A B C D E F
SKU Flyer# s p description sr#
6338016 17 18 Seat SR360
6338016 17 18 Seat SR812
6338016 17 40 Seat SR698
6338016 17 18 Seat SR872

I have tried Vlookup and Index(Match but nothing works.

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
lookup with multiple condition, but one condition to satisfy is en Eddy Stan Excel Worksheet Functions 2 October 27th 07 02:06 PM
Combine an OR condition with an AND condition Will Excel Discussion (Misc queries) 1 April 6th 07 03:52 PM
If condition Lavanya Excel Discussion (Misc queries) 4 November 20th 06 09:56 AM
Condition 1 overules condition 2? Bultgren Excel Worksheet Functions 2 January 20th 06 01:29 PM
I need 4 condition for condition formatting SeeKY Excel Programming 2 June 7th 05 09:41 AM

All times are GMT +1. The time now is 08:04 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017