nav2567
asked on
Compare column in Excel.
Hello,
I just posted a question but the solution I got does work work 100% so I am re-posting this.
************************** ********** ********** ********** ********** ********** ********** ********** ********** ********** ********** **
I have the attached spreadsheet which I want to find the OS of each computer in column A using column D and column E.
For example, computer 1 in column A appears in column D, I want the OS in column E being copied to column B.
Please advise a formula I can use in column B.
Please note that I have about 3000 rows in the spreadsheet.
Many thanks.
OS-searchup.xlsx
I just posted a question but the solution I got does work work 100% so I am re-posting this.
**************************
I have the attached spreadsheet which I want to find the OS of each computer in column A using column D and column E.
For example, computer 1 in column A appears in column D, I want the OS in column E being copied to column B.
Please advise a formula I can use in column B.
Please note that I have about 3000 rows in the spreadsheet.
Many thanks.
OS-searchup.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may try this...
In B2
Btw if your main concern is, why the formula doesn't return Windows 10 in B5, that's because computer6 (A5) doesn't match with computer 6 (D7).
In B2
=IFERROR(VLOOKUP(A2,D:E,2,0),"")
and copy it down.Btw if your main concern is, why the formula doesn't return Windows 10 in B5, that's because computer6 (A5) doesn't match with computer 6 (D7).
ASKER
Thanks, everyone!!!
or
=IFERROR(VLOOKUP(A2,$D$2:$