B
bamafamily
Hey All,
I just found this forum and it looks great!!
I have had a problem for quite some time and can't seem to get it t
work..
Excel2003:
I have column headings labeled: Orange, green, red, blue in B1:E
respectively
I have Row headings labeled: car, boat, plane, train in A2:A
respectively
I have numerical data in B2:E5
I want to search/find the value in the range B2:E5 and return BOTH th
row and column heading
Example:
the value 222 is in cell E5
I want to search/find 222 and return the 2 values of "Blue" an
"Train"
Is this possible with just a function??
Does it have to match exactly or can it be "+-1"?(assuming intege
data)
If the value appears more than once, can I return more than 1 set o
values??
thx for all the help
Bam
I just found this forum and it looks great!!
I have had a problem for quite some time and can't seem to get it t
work..
Excel2003:
I have column headings labeled: Orange, green, red, blue in B1:E
respectively
I have Row headings labeled: car, boat, plane, train in A2:A
respectively
I have numerical data in B2:E5
I want to search/find the value in the range B2:E5 and return BOTH th
row and column heading
Example:
the value 222 is in cell E5
I want to search/find 222 and return the 2 values of "Blue" an
"Train"
Is this possible with just a function??
Does it have to match exactly or can it be "+-1"?(assuming intege
data)
If the value appears more than once, can I return more than 1 set o
values??
thx for all the help
Bam