VLOOKUP (?)

[an]

Hello!

I would like formulae to result in Column D:

A B C D
1 10 aaa aaa 10
2 11 bbb bbb 11
3 12 ccc aaa 10
4 ccc 12
5 ccc 12
6 aaa 10
7 bbb 11
8 aaa 10
9 aaa 10
10 ... ...

Thanks in advance.
an

 

[JulieD]

Hi

could you provide a bit more detail ... in rows 1 &2 you have information in
columns A, B, C and D - where C & D is the reverse of A & B. However, in
row 3 this doesn't hold true. Then in rows 4 through 9 as far as i can tell
you have data in columns C & D
so i'm not really sure what you mean by a result in column D.

Cheers
JulieD

 

[an]

Ok.
Thanks for your reply.
I Have a block in A1:B3 (only) with corresponding numeric
values in "A" and strings in "B" Column.
But:
I have a block in C1:C1000 with strins.
Now:
I would like a formulae to put in D11000, where
numerical values they were corresponding the same string
for comparison between "A" and "B" columns.

Thanks.
an

 

[JulieD]

Hi an

in D1 the formula would be
=LOOKUP(C1,$B$1:$B$3,$A$1:$A$3)

this formula can then be copied down column D

Hope this helps
Cheers
JulieD

 

[an]

Ooops!

The formulae work fine...

But, If to exist in "C" column a string without
corresponding in "B" Column, the corresponding value
in "D" Column, up one row (?).

How is it possible to correct this, please?
=IF(...

Many thanks.
an

 

[JulieD]

Hi an

then try
=INDEX($A$1:$B$3,MATCH(C1,$B$1:$B$3,0),1)

this will return a #NA error if the value is not found in column B

to deal with this you can do something along the lines of
=IF(ISNA(INDEX($A$1:$B$3,MATCH(C1,$B$1:$B$3,0),1)),"",INDEX($A$1:$B$3,MATCH(C1,$B$1:$B$3,0),1))

which says if the value in column C is not found in column B then return
"nothing" otherwise match the values.

Hope this helps
Cheers
JulieD

 

[an]

Exactly, JulieD

You helped me very much.

Have you a good week.
an

 

[JulieD]

glad it works - you have a great week too

Exactly, JulieD

You helped me very much.

Have you a good week.
an