Good morning,
My issue is difficult to explain, so please see attached document for an example of the formula I need.
Thanks in advance!
Calculator Example.xlsx
Good morning,
My issue is difficult to explain, so please see attached document for an example of the formula I need.
Thanks in advance!
Calculator Example.xlsx
In B3 and filled right to E3
=VLOOKUP(B$2,$A$9:$B$14,2,FALSE)
In cell B3 put =VLOOKUP(B$2,$A$9:$B$14,2,FALSE) and copy across
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Thank you both. it works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks