Excel Help

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

I have two worksheets. In the first worksheet I have 1 column (column a1) with numbers in them, on the second worksheet I have 2 columns with number (column "a" and "b"). I want a formula that will search for the numbers is column "a1" in the second worksheet in column "a", and if it finds a match I want it to insert the number that is in column "b" on the first worksheet.

So basically I have 2 lists. I want to match the information from both worksheets without me going through 10,000+ lines manually and insert the one column that I need to add. Some of the numbers that I am searching for from the first worksheet will not be in the second worksheet. The number that match I want the information that is in the next column of the second worksheet to show up in the first worksheet. I guess I need to match up all the information that is not in worksheet 1 to worksheet 2.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
in sheet 1 data is in column A like this h1
1
2
3
4
5
in sheet 2
in colum A and B like this h1 h2
1 9
2 8
3 7
4 6
5 5
6 4
7 3
8 2
9 1

in SHEET 1 in cell B2 copy paste this formula

=VLOOKUP(A2,Sheet2!$A$1:$B$10000,2,0)
copy B2 in sheet 1 dawon
this will work for 10000 rows if more change that 10000 in the formula suitably

if this solution is ok confirm

study about vlookup function in excel help. it is a useful function.