Index Match Function Question
Thank you very much, that worked!
"JMB" wrote:
Assuming your database is in A1:G100, criteria are in cell1, cell2, cell3,
cell4, try:
=INDEX(G1:G100, MATCH(cell1&cell2&cell3&cell4,
A1:A100&B1:B100&C1:C100&D1:D100, 0))
entered w/Cntrl+Shift+Enter or you'll get #VALUE!
Alternatively, insert a column in your data (lets say column A - so
everything shifts one column to the right) and concatenate the four columns
you are using as a lookup
=B1&C1&D1&E1
copy it down your table, then use VLOOKUP
=VLOOKUP(cell1&cell2&cell3&cell4, A1:H100, 8, 0)
"excelnewbie44" wrote:
I have a large database set up with information in cells A-G. Cells A-D
contain unique information and I would like to create a function that will
find when the criteria matches these four cells it pulls in the answer in the
7th cell (G). I hope this makes sense. I tried to set up a INDEX-MATCH
function but have been unsuccessful so far. Is this the right function to
use? If so, do you know the general format I should be using to set this up?
|