How can we find the location from the amount paid and date
Please Login or Register to view this content.
How can we find the location from the amount paid and date
Please Login or Register to view this content.
Last edited by 6StringJazzer; 02-27-2023 at 11:04 AM. Reason: Added code tags for data formatting
Your data is clear but your question is not. We need an example of input and results.
I assume the numbers are the "amount paid."
No idea what "location" means in your question. Are A-B-C-D locations of some kind?
XLOOKUP finds a value in one row or column, and returns the value in another row or column corresponding to what it found. I don't think that is what you are trying to do.
Do you mean that you want to specify 07/03/2023 and 100, and return "C"?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Attachment 819432Attachment 819432.
How can I find (A, B, C or D) based on table values dates and amount
I have date and the amount (ie 07/03/2023 and 100- Can we find whether it is (A, B, C or D)Book5.xlsx
Last edited by Finexbpo; 02-27-2023 at 11:23 AM.
N15
=2023/3/7
o15
=100
p15
=iferror(index(9:9,match(o15,index($1:$100,match(n15,h:h,0),),0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks