Test.xlsx
Hi Everyone
On the attached file I'm looking for a formula that looks at the values in H, F and B columns and looks them up in the Available TAB and if these three values matches return the value in Column F from Available Tab into the L column in the ZONE TAB.
Thank you very much in advance you guys are great.
Hi,
try
Formula:
Please Login or Register to view this content.
Last edited by tanasedn; 02-03-2023 at 05:37 PM.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Sorry formula is not working.
In your sample you don't have a match. Is working. It returns blank.
In column B in Zone tab you have only A01 code that not match any in Available sheet
Yes on my example there are no matches but once I create invneotry in the bab the formula works. the problem I have is once I drag the formula down to my last record the parameters also change where it starts looking for matches out of range returning no values. can this be prevented?
thank you
Maybe, if you can upload a sample with that issue
Why in the world would you supply a sample file where nothing matches?!
A slight change to the formula above (so when it's copied down it still works):
=XLOOKUP(H2&F2&B2,Available!$A$2:$A$6&Available!$C$2:$C$6&Available!$B$2:$B$6,Available!$F$2:$F$6,"not found",0)
Or try this
=LOOKUP(2,1/(Available!$B$2:$B$6=B2)/(Available!$A$2:$A$6=H2)/(Available!$C$2:$C$6=F2),Available!$F$2:$F$6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks