Matching of 2 cells &display corres 3rd cell

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

In Sheet 1 I should give two input DATA and this data will available in sheet 2 .excel should match the given inputs and result must get display of the corresponding third cell in the sheet 1

eg. data in sheet 2 are given

A B C
xxx 1243 oksd
yyy 4564 dodf
zzz 1245 offjsd
aaa 2323 kjdfsd
bbb 2132 sdjfs
bbb 2245 sjhsfdsh
now in sheet one i should give
aaa
2323
result should be--------- kjdfsd(third corresponding)

please help me

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
the main daa is sheet is from A1:c1 dwon

if 2323 is in A2 in sheet 2 , in B2 (or any otehr empty cell ) in sheet2 copy paste this formla

=VLOOKUP(A2,Sheet1!$B$1:$C$100,2,0)

if there are other entries in A33,A4 etc you can copy B2 dwon.

I visualized 100 rows in sheet 1 , if more change C100 to suitable entry in the formula.