Hello!
Please can someone possibly help?
See attached my spreadsheet for reference
What I am trying to do is in cell F7, I'm trying to get the relevant sale price dependant on the value in cell F4.
e.g F4= -70 and so F7 should equal F20.
Is this possible to do?
Many thanks in advance,
Try
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you Fotis1991!
I've had to mark this as unsolved as I've just realised it's only giving me a value if it matches a figure on the list, instead of a range
e.g. F4 = -68 and as this isn't on the list it isn't picking it up because it doesn't match anything. I need Excel to return a value using the full range of numbers. Not just -66 or -70, I need it to pick up on -67, -68, and -69 also.
Can this be done?
=INDEX(F12:F25,MATCH(F4,B12:B25,-1))
Try this formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi,
try this .
Made some changes in format in "Debtor days" in column B & D
Punnam
Hi,
maybe
=INDEX(F12:F25,MATCH(1,INDEX((B12:B25>=F4)*(D12:D25<=F4),),0))
Cheers
------------------------------
Ciao Fotis!
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi, Refer the attachment...
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks