vatsayana Posted January 11, 2023 Report Share Posted January 11, 2023 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. Quote Link to comment Share on other sites More sharing options...
HugoStrange Posted January 11, 2023 Report Share Posted January 11, 2023 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 1 Quote Link to comment Share on other sites More sharing options...
vatsayana Posted January 11, 2023 Author Report Share Posted January 11, 2023 3 minutes ago, HugoStrange said: =vlookup(columnA, (select $x&$Y), 2, false) kaka x,y ante motham table select chesuko Thx baa. will try Quote Link to comment Share on other sites More sharing options...
.thumb.jpg.abf7d08f99d33f7507f9f0e982085cc3.jpg)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.