philwes83170
MIS
I have two sheets, one contains data imported from a database the second will display parts of the data.
Sheet 1 looks something like this:
Name Qtr Amount
Smith Q1 1000
Smith Q2 1000
Jones Q1 800
Jones Q2 500
Sheet 2 looks like this:
Qtr1 Qtr2
Smith
Jones
I'd like to get a lookup to find the values from sheet one, but can't seem to find a function that will do an "AND". If I could get something like this VLOOKUP(A2 and "Q1", sheet1!table, 3)
Thanks in advance for your help.
Sheet 1 looks something like this:
Name Qtr Amount
Smith Q1 1000
Smith Q2 1000
Jones Q1 800
Jones Q2 500
Sheet 2 looks like this:
Qtr1 Qtr2
Smith
Jones
I'd like to get a lookup to find the values from sheet one, but can't seem to find a function that will do an "AND". If I could get something like this VLOOKUP(A2 and "Q1", sheet1!table, 3)
Thanks in advance for your help.