Hi Budget Programmer and Vonner,
My forte is not
VB . . . so I’m sure there are more savvy ways o
doing this but here’s a sample of my formula I created for a doubl
criteria search, based on your example (Budget Programmer)
=INDEX(DATA_FEED!$F$2:$F$10,MATCH(CONCATENATE(QUER Y!$A2,QUERY!B$1),DATA_FEED!$E$2:$E$10,0))
Attached is an of my formula using your example for your review
hopefully this will get you closer to what your looking for.
/// Caution this formula when copied over & over in a sheet, wil
consume recalculating time /// that’s why I’m in looking into
VB or SQ
options (faster). But in the meantime server me well. FYI this will onl
works for unique records / criteria. Otherwise it will return the 1s
value it encounters and discard the others thus skewing your results.
Fable
Remember help others when ever your can
Attachment filename: index (2 criteria search).xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=69788
--
Message posted from
http://www.ExcelForum.com