Forum Discussion
Solved
Excel formula help
Hi sir/Madam, I am really struggling to compare and display the values in excel. My requirement: I have excel sheet with two tabs. First tab has two columns A and B. A is having values of i...
Hi, to all!
Check file with an option. Blessings!
you can use VLOOKUP to bring the values from column B of both the sheets. the formula will throw an error when it cant find match for the given incident number in the second sheet which we will handle by using IFERROR and returning the string "No match" in case of error. so the formula for column B in sampleresultsheet will be:
=VLOOKUP(A2,'First Sheet'!$A$2:$B$391,2,0)
and the formula for column C will be:
=IFERROR(VLOOKUP(A2,'Second sheet'!$A$2:$B$173,2,0),"No match")
=VLOOKUP(A2,'First Sheet'!$A$2:$B$391,2,0)
and the formula for column C will be:
=IFERROR(VLOOKUP(A2,'Second sheet'!$A$2:$B$173,2,0),"No match")
Dear Takmil, Really Thanks for your valuable assistance.