Compare cells and copy values
Hi
I use Windows 10 Pro and MS Office 2013
Here is my requirement:
If A2 is there in Column Q(eg: Q3)
and if B2 = R3(Q's subsequent Cell)
Then O2 should display S3(R's subsequent Cell value) and
P2 should display T3 (S's subsequent cell value)
If I am not clear or you have any doubt I have attached an Excel sheet.
In which I have filled Column 'O' and column 'P' manually where i wish to have the formulas.
Thank you for you time
Your output data is incorrect B6 is "Carewise", R7 is "CAREWISE " with a space, these are not the same hence your results are incorrect.
Correct the error so B6 matches R7 then
in O2
=IFERROR(VLOOKUP(A2,IF(B2=R$2:R$15,Q$2:T$15),3,0),"")
in P2
=IFERROR(VLOOKUP(A2,IF(B2=R$2:R$15,Q$2:T$15),4,0),"")
Array formulas, use Ctrl-Shift-Enter
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Here is non array formula.
In O2 then drag across.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks