Multiple If function

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
648
Office Version
  1. 2019
Platform
  1. Windows
Hello,
After sorting the data by ID No. with the help of a formula in column D, I am trying to get the name in column D as per books, IF THE ID no. is the same else it should display the same in Portal if the ID does not match. Like this formula '=IF(B2=B3, C=D3, E2).
QUERY NEW.xlsx
ABCDE
1DateAs PerID NO.FormulaNAME
201-02-2021Portal1234SUNDAYJANUARY
301-02-2021Books1234SUNDAYSUNDAY
401-02-2021Portal1234FEBRUARYJANUARY
501-02-2021Books2345FEBRUARYFEBRUARY
601-02-2021Portal2345MARCHMONDAY
701-02-2021Portal8888DECEMBERDECEMBER
801-02-2021Books3456MARCHMARCH
901-02-2021Portal3456MARCHTUESDAY
1001-02-2021Books4567MARCHMARCH
1101-02-2021Portal5678MAYWEDNESDAY
1201-02-2021Books5678MAYMAY
1301-02-2021Portal6789MONDAYFEBRUARY
1401-02-2021Books6789MONDAYMONDAY
1501-02-2021Portal7890APRILMARCH
1601-02-2021Books7890APRILAPRIL
1701-02-2021Portal1111MercuryMAY
1801-02-2021Books1111MercuryMercury
1901-02-2021Portal2222JupiterJUNE
2001-02-2021Books2222JupiterJupiter
2101-02-2021Portal3333PlutoJULY
2201-02-2021Books3333PlutoPluto
2301-02-2021Portal4444AUGUSTAUGUST
2401-02-2021Portal5555SEPTEMBERSEPTEMBER
2501-02-2021Portal6666OCTOBEROCTOBER
2601-02-2021Portal7777NOVEMBERNOVEMBER
Reconcile
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,542
Office Version
  1. 365
Platform
  1. Windows
That still appears to be riddled with errors but now that you have finally clarified the points that I raised in post 2, it gives me enough to work with.
If you had taken the time to check that your original example was correct before posting then this could have been resolved in 1 or 2 replies, not 10 or more.

Given that this is a fairly simple question I suspect that the lack of clarity in the question along with the obvious inaccuracy of the sample would be the reason why your thread went unanswered for around 4 hours. Normally something so simple with an accurate example would be resolved within a few minutes.

Book3
ABCDEFGH
1DateAs PerID NO.FormulaNAMEYour example
201-Feb-21Portal1111MercuryMAYMercury 
301-Feb-21Books1111MercuryMercuryMercury 
401-Feb-21Portal1234SUNDAYJANUARYSUNDAY 
501-Feb-21Books1234SUNDAYSUNDAYSUNDAY 
601-Feb-21Portal1234SUNDAYJANUARYSUNDAY 
701-Feb-21Portal1234SUNDAYJANUARYSUNDAY 
801-Feb-21Portal2222JupiterJUNEJupiter 
901-Feb-21Books2222JupiterJupiterJupiter 
1001-Feb-21Books2345FEBRUARYFEBRUARYMONDAYDifferent
1101-Feb-21Portal2345FEBRUARYMONDAYMONDAYDifferent
1201-Feb-21Portal3333PlutoJULYPluto 
1301-Feb-21Books3333PlutoPlutoPluto 
1401-Feb-21Books3456MARCHMARCHMARCH 
1501-Feb-21Portal3456MARCHTUESDAYMARCH 
1601-Feb-21Portal4444AUGUSTAUGUSTAUGUST 
1701-Feb-21Books4567MARCHMARCHMARCH 
1801-Feb-21Portal5555SEPTEMBERSEPTEMBERSEPTEMBER 
1901-Feb-21Portal5678MAYWEDNESDAYMAY 
2001-Feb-21Books5678MAYMAYMAY 
2101-Feb-21Portal6666OCTOBEROCTOBEROCTOBER 
2201-Feb-21Portal6789MONDAYFEBRUARYMONDAY 
2301-Feb-21Books6789MONDAYMONDAYMONDAY 
2401-Feb-21Portal7777NOVEMBERNOVEMBERNOVEMBER 
2501-Feb-21Portal7890APRILMARCHAPRIL 
2601-Feb-21Books7890APRILAPRILAPRIL 
2701-Feb-21Portal8888DECEMBERDECEMBERMARCHDifferent
Sheet3
Cell Formulas
RangeFormula
D2:D27D2=IFERROR(LOOKUP(2,1/($C$2:$C$27=C2)/($B$2:$B$27="Books"),$E$2:$E$27),E2)
H2:H27H2=IF(D2=G2,"","Different")
 
Solution

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
648
Office Version
  1. 2019
Platform
  1. Windows
That still appears to be riddled with errors but now that you have finally clarified the points that I raised in post 2, it gives me enough to work with.
If you had taken the time to check that your original example was correct before posting then this could have been resolved in 1 or 2 replies, not 10 or more.

Given that this is a fairly simple question I suspect that the lack of clarity in the question along with the obvious inaccuracy of the sample would be the reason why your thread went unanswered for around 4 hours. Normally something so simple with an accurate example would be resolved within a few minutes.

Book3
ABCDEFGH
1DateAs PerID NO.FormulaNAMEYour example
201-Feb-21Portal1111MercuryMAYMercury 
301-Feb-21Books1111MercuryMercuryMercury 
401-Feb-21Portal1234SUNDAYJANUARYSUNDAY 
501-Feb-21Books1234SUNDAYSUNDAYSUNDAY 
601-Feb-21Portal1234SUNDAYJANUARYSUNDAY 
701-Feb-21Portal1234SUNDAYJANUARYSUNDAY 
801-Feb-21Portal2222JupiterJUNEJupiter 
901-Feb-21Books2222JupiterJupiterJupiter 
1001-Feb-21Books2345FEBRUARYFEBRUARYMONDAYDifferent
1101-Feb-21Portal2345FEBRUARYMONDAYMONDAYDifferent
1201-Feb-21Portal3333PlutoJULYPluto 
1301-Feb-21Books3333PlutoPlutoPluto 
1401-Feb-21Books3456MARCHMARCHMARCH 
1501-Feb-21Portal3456MARCHTUESDAYMARCH 
1601-Feb-21Portal4444AUGUSTAUGUSTAUGUST 
1701-Feb-21Books4567MARCHMARCHMARCH 
1801-Feb-21Portal5555SEPTEMBERSEPTEMBERSEPTEMBER 
1901-Feb-21Portal5678MAYWEDNESDAYMAY 
2001-Feb-21Books5678MAYMAYMAY 
2101-Feb-21Portal6666OCTOBEROCTOBEROCTOBER 
2201-Feb-21Portal6789MONDAYFEBRUARYMONDAY 
2301-Feb-21Books6789MONDAYMONDAYMONDAY 
2401-Feb-21Portal7777NOVEMBERNOVEMBERNOVEMBER 
2501-Feb-21Portal7890APRILMARCHAPRIL 
2601-Feb-21Books7890APRILAPRILAPRIL 
2701-Feb-21Portal8888DECEMBERDECEMBERMARCHDifferent
Sheet3
Cell Formulas
RangeFormula
D2:D27D2=IFERROR(LOOKUP(2,1/($C$2:$C$27=C2)/($B$2:$B$27="Books"),$E$2:$E$27),E2)
H2:H27H2=IF(D2=G2,"","Different")
Sorry Once again man, Yeah I see the errors. Give me some time. Let me make a new sheet.
 

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
648
Office Version
  1. 2019
Platform
  1. Windows
No point, as I already said

Just try the formula in your proper sheet and see if it works there.
Jason. It's perfect As you said any question can be resolved in one or two replies. I agree with you. But as I am new, and learning both accounts and excel simultaneously, I do make silly mistakes and sometimes I am not able to ask the right question. But I am learning and improving everyday. Thanks for your patience man.
 

Forum statistics

Threads
1,141,417
Messages
5,706,311
Members
421,441
Latest member
VapesRub

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top