Look Up help (repost)

[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

 

[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.

This one is about as clear as mud, too.

 

[Bob I]

Use "=IF(B2,B2,"")", copy and paste to fill other cells