genracela
05-25-2010, 09:27 PM
I created a search file, and I need to do a match index vlookup formula.
I already tried a different match index vlookup approach but I just can't get this right.
Please help, I' just actually trying to get the formulas correct, I don't really need VBA code yet. But if the solution to this file is a VBA then the better, since I'll be converting this to VBA also. But right now, what I really need is a cell formula.
I just really need to convert this condition to formula:
IF E6(SEARCH TAB) is equal to range D6:D4000 or G6:G4000 or J6:J4000 or M6:M4000 or P6:P4000 or S6:S4000 or V6:V4000 or Y6:Y4000(SOURCE TAB)
And
IF C12(SEARCH TAB) is equal to range D4 or G4 or J4 or M4 or P4 or S4 or V4(SOURCE TAB)
Then
Return the value of range A6:A4000(SOURCE TAB)
Thanks!
I already tried a different match index vlookup approach but I just can't get this right.
Please help, I' just actually trying to get the formulas correct, I don't really need VBA code yet. But if the solution to this file is a VBA then the better, since I'll be converting this to VBA also. But right now, what I really need is a cell formula.
I just really need to convert this condition to formula:
IF E6(SEARCH TAB) is equal to range D6:D4000 or G6:G4000 or J6:J4000 or M6:M4000 or P6:P4000 or S6:S4000 or V6:V4000 or Y6:Y4000(SOURCE TAB)
And
IF C12(SEARCH TAB) is equal to range D4 or G4 or J4 or M4 or P4 or S4 or V4(SOURCE TAB)
Then
Return the value of range A6:A4000(SOURCE TAB)
Thanks!