xlookup multi-criteria

Im sure this may be a bit confusing, but i have a database similar to the first image. What i want to do is, based on the data on "Info" ranges, apply a value to the "Value" ranges. For that i had formulas such as "=if(A1 = "A",1,0)" or "=if(and(B1 = "red",C1 = "pear"),1,0)" which would get me...

G'day. Am in need of some help and I'm not totally sure where to start in getting this to work. Maybe an XLOOKUP, but I really can't figure out how to lookup one value, and then another, and then produce the result. I have attached part of the sheet via XL2BB below. What I need is the table on...

I have 3 worksheets: "Input Data". has 5k+ rows and 20 columns. "TeamInfo" has 20 rows and 5 columns. "Output" processes all rows from Input and merging the TeamInfo data. I want to do a SINGLE lookup that returns multiple rows and columns from TeamInfo. I found that both VLookup and...

I am trying for a formula to cross reference between the number of sessions John Doe has purchased and the days they are valid to then countdown each time a session is used up. Formulas to go in the following columns: Column F for the Gym locations Column G for the Outdoor locations Screenshot...

This is a simplified version of what I need to do; to summarize the situation: - I have a table with many columns (only 3 are relevant for now) - Some of the rows may contain identical data in these columns (ex. the duplicate Shirt-Red-A) - I need a single cell to contain the "Brands" that have...

Dear All, I am trying to do do a lookup based on two criteria, if the criteria matches, then it should not give all the results but the result I want. I tried various formulas on internet on Xlookup but not working and then I came across Filter function which is close to what I want but still...

Hi, I have below table and what I need is to get the count based on selected team for each tenure, I was trying to use the xlookup but it's not working, as it's giving me #VALUE, can anyone help me with refining the formula to get the same as expected results column...

Hello, I'm trying to get a VBA macro to COPY a value to the Windows Clipboard based on two Criteria. I'm running a test using some sample data to match the Name and Library to a given Card number. What I'm working with so far... I've tested two different formula versions of using...