Hi
tried v-lookup and it is not working
In the pay worksheet when the month in cell s44 is selected I want in v44 to display the answer.
The answer for v44 would be picked up from the budget worksheet cell Q9-U9.
Hi
tried v-lookup and it is not working
In the pay worksheet when the month in cell s44 is selected I want in v44 to display the answer.
The answer for v44 would be picked up from the budget worksheet cell Q9-U9.
instead of vlookup try Hlookup like below
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Wrong thread. Answer deleted
its comes back with an error when i change the month to feb-16
can you help me with this one?
Try
=INDEX(budget!Q9:U9,,MATCH(S44,budget!Q5:U5,0))
John can you help me on this thread V-Lookup Problem not working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks