I need to compare cell H4 to the list R8-22 and find the closest match, then return the corresponding number in list Q8-22 to cell J4.
Any ideas
I need to compare cell H4 to the list R8-22 and find the closest match, then return the corresponding number in list Q8-22 to cell J4.
Any ideas
try: =INDEX($Q$8:$Q$22,MATCH(H4,$R$8:$R$22,1))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks