![]() |
|
|
|
#1
|
||||
|
||||
|
I hope this is also OK for MAC, but try the following
in the "test master" sheet in F4 enter Code:
= A4&B4 in the "test medical" one in C4 enter Code:
=VLOOKUP(A4&B4,CHOOSE({1,2},'[test master.xlsx]Sheet1'!$F$4:$F$30,'[test master.xlsx]Sheet1'!$E$4:$E$30),2,0)
Code:
=VLOOKUP(A4&B4,CHOOSE({1,2},'[test master.xlsx]Sheet1'!$F$4:$F$30,'[test master.xlsx]Sheet1'!$C$4:$C$30),2,0)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
#2
|
|||
|
|||
|
excellent! i'll try it monday and let you know if it works. where do i find formulas like this one? i have an excel 2007 formulas book but i didn't find anything like this in there.
|
|
| Tags |
| multi-criteria, vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
| Sum Product Multiple Text and date Criteria | ramki | Excel | 1 | 01-09-2012 01:16 AM |
Multiple VLOOKUP's checking multiple Cells
|
OTPM | Excel | 11 | 05-23-2011 11:18 AM |
Excel Vlookup
|
jtej009 | Excel | 1 | 02-10-2011 03:25 AM |
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |