Matching of 2 cells &display corres 3rd cell
Closed
kishore
-
Sep 7, 2009 at 03:56 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 7, 2009 at 09:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 7, 2009 at 09:08 PM
Related:
- Matching of 2 cells &display corres 3rd cell
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Resident evil 2 remake download - Download - Horror
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 7, 2009 at 09:08 PM
Sep 7, 2009 at 09:08 PM
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.
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.
