D
DF
Good day all!
2 sheets named "map" and "data"
The data sheet contains information from a database query and thus
headers exist in row 1. The real data starts in A2 and extends to
I2000. I only need the information in columns A and B to complete
this task.
The data is arranged in ascending order. Column A contains numbers
from 1 to something, and column B contains numbers from 1 up to 31.
For example, cell A2=1, B2=1, A3=1, B3=2, etc.
I am attempting to display this information in a map format on the map
sheet.
The map sheet is arranged as follows (a grid-like format):
Columns:
A1= a label, B1=1, C1=2 through AF1=31 (possible numbers from the
data sheet column B).
Rows:
A2=1, A3=2, etc.
My question is this. What would be a good formula to use to look up
if a value exists referencing the row and column values from the map
sheet in the array of data on the data sheet and return a space if it
does and nothing if it does not?
So, in cell B2, return a space if A2 exists in data!A2:A:2000 AND if
B1 exists in data!B2:B2000. To clarify, if possible, the row data
does not repeat, for example, there is only one row with the value 1
in A and 1 in B, 1 in A and 2 in B, etc.
I've used a few examples such as: http://office.microsoft.com/en-us/excel/HA012260381033.aspx
for reference. But, I cannot seem to get it to work completely. I am
not very astute when it comes to array formulas.
Thanks in advance for any help that anyone can give me in this area.
--DFruge
2 sheets named "map" and "data"
The data sheet contains information from a database query and thus
headers exist in row 1. The real data starts in A2 and extends to
I2000. I only need the information in columns A and B to complete
this task.
The data is arranged in ascending order. Column A contains numbers
from 1 to something, and column B contains numbers from 1 up to 31.
For example, cell A2=1, B2=1, A3=1, B3=2, etc.
I am attempting to display this information in a map format on the map
sheet.
The map sheet is arranged as follows (a grid-like format):
Columns:
A1= a label, B1=1, C1=2 through AF1=31 (possible numbers from the
data sheet column B).
Rows:
A2=1, A3=2, etc.
My question is this. What would be a good formula to use to look up
if a value exists referencing the row and column values from the map
sheet in the array of data on the data sheet and return a space if it
does and nothing if it does not?
So, in cell B2, return a space if A2 exists in data!A2:A:2000 AND if
B1 exists in data!B2:B2000. To clarify, if possible, the row data
does not repeat, for example, there is only one row with the value 1
in A and 1 in B, 1 in A and 2 in B, etc.
I've used a few examples such as: http://office.microsoft.com/en-us/excel/HA012260381033.aspx
for reference. But, I cannot seem to get it to work completely. I am
not very astute when it comes to array formulas.
Thanks in advance for any help that anyone can give me in this area.
--DFruge