Look Up help (repost)

D

DF

Given the following sample data and layout:

"data" sheet items sample
A B
1 1 1
2 1 2
3 1 3
4 1 4
5 1 5
6 1 6
7 2 1
8 2 2

"map" sheet layout sample
A B C D E F
1 1 2 3 4 5
2 1 ?
3 2
4 3
5 4
6 5

Could someone assist me with a look up formula for cells B2 - end to
look if the data exists in data sheet list? If it does exist, then
return "x"; if not, do nothing. Thank you in advance for any help.
This is a repost of a previous message that I'm sure was not very
clear.

--DFruge
 
A

anon

Given the following sample data and layout:

"data" sheet items sample
A B
1 1 1
2 1 2
3 1 3
4 1 4
5 1 5
6 1 6
7 2 1
8 2 2

"map" sheet layout sample
A B C D E F
1 1 2 3 4 5
2 1 ?
3 2
4 3
5 4
6 5

Could someone assist me with a look up formula for cells B2 - end to
look if the data exists in data sheet list? If it does exist, then
return "x"; if not, do nothing. Thank you in advance for any help.
This is a repost of a previous message that I'm sure was not very
clear.
Click to expand...

This one is about as clear as mud, too.
 
Top