[Help] Excel question.

[vatsayana]

Hello Excel experts, 

can someone help me with this thing. Lets say for example:

I have a workbook with two work sheets

Worksheet 1 has two columns A & B
Worksheet 2 has two columns X & Y

I need to check each cell from Worksheet 1 column A with Worksheet 2 Column X and if I find it, I need to place the corresponding Y value in Column B.

Any idea how to do it? 

TIA.

[HugoStrange]

4 minutes ago, vatsayana said:

Hello Excel experts, 

can someone help me with this thing. Lets say for example:

I have a workbook with two work sheets

Worksheet 1 has two columns A & B
Worksheet 2 has two columns X & Y

I need to check each cell from Worksheet 1 column A with Worksheet 2 Column X and if I find it, I need to place the corresponding Y value in Column B.

Any idea how to do it? 

TIA.

=vlookup(columnA, (select $x&$Y), 2, false)

kaka

x,y ante motham table select chesuko

[vatsayana]

3 minutes ago, HugoStrange said:

=vlookup(columnA, (select $x&$Y), 2, false)

kaka

x,y ante motham table select chesuko

Thx baa. will try