Hey All,
Need help with populating D2 with a car make from column B, if A2 contains one of the makes in column B.
Same thing with populating E2 with a car model from column C, if A2 contains one of the models in column C.
I really hope a formula like this exists!!
Last edited by MilkyMotorsports; 03-10-2022 at 09:26 PM.
Cell D2 formula , Drag down and across
Formula:
=LOOKUP(,-FIND(B2,$A2),B2)
office 365
Cell D2 , Drag down
Formula:=FILTER(B2:C2,ISNUMBER(FIND(B2:C2,A2)))
Last edited by wk9128; 03-10-2022 at 08:23 PM.
No that doesn't work how I need it to. This would be closer, but it doesn't work:
=LOOKUP(,-FIND(B:B,$A2),B:B)
I don't understand what you mean, please see the attachment
It doesn't work how I need it to.
D4 & D5 need to have data, not 0s
@MilkyMotorsports Wait, D4 AND D5 What do you hope for?
Could you pls put the results you expect in columns D and E?
I'm on the way to my office, I'm free to answer your questions later
Last edited by wk9128; 03-10-2022 at 08:48 PM.
What I'm looking for is attached -
Cell D2 formula , Drag down and across
Formula:=IFERROR(LOOKUP(,-FIND(B$2:B$5,$A2),B$2:B$5),"")
Last edited by wk9128; 03-10-2022 at 09:48 PM.
Oh my god i love you thank you
@MilkyMotorsports You're Welcome. Glad to help . Thank You for the feedback
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- Please click on the *Add Reputation button at the bottom left. Whoever helps you, give it to whoever you like
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks