lookup data based on interval and another cell
Data is required to be pulled out from a lookup table and displayed in in the output cell G6 based on data in cell G4 AND G5
Formula used in G6 is
Formula:
Please Login or Register to view this content.
But, it is returning “FALSE” for certain combinations of G4 and G5. How can the formula be corrected?
exc.jpg
Workbook
https://bit.ly/workbk3004
Please attach the workbook here - we have an attachment facility (instructions at the top of the page) so nobody should need to follow an external link in order to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please Login or Register to view this content.in additional the file with picture is the same as screenshot without file.so nobody should need to follow an external link in order to help you
Last edited by BMV; 04-30-2020 at 12:51 PM.
I tried this formula but it returns an error.
workbook attached herewith
I think we have different regional settings.
With a little adjustments this will also work
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks