Good day,
need your help with arranging a code that when enter a booking no will return values on "recap" sheet based on booking no entered in B3 from "sheet1" column U & V but spiking blank cells. Book no on Sheet1 can appear more than once in column so VLOOKUP function is returning just a first value.
Pls find attached a sample file.
https://www.dropbox.com/s/3oi2gd93lf...TEST.xlsx?dl=0
brgds,
forfiett
First make changes in sheet recap as below.
BOOK NO VALUE1 VALUE2
55556 12234 596
Now
U2Formula:
Please Login or Register to view this content.
Check the attached file.
Hope this will help you.
Last edited by shukla.ankur281190; 10-20-2016 at 03:15 AM. Reason: Missed Info
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Dear,
thanks for help but it is not working for me.
I need that on recap sheet based on BOOK NO displays VALUE1 and VALUE2 from sheet2.
thanks.
Ohkay
Try
B4 in recap sheet
B4Formula:Please Login or Register to view this content.
working well!! thanks
another question, it is possible to display all matches? if one booking has more than one match to display all of them (uner value1 or 2)
working well!! thanks
another question, it is possible to display all matches? if one booking has more than one match to display all of them (uner value1 or 2)
Yes it can be possible.
If you have got your solution please mark thread as solved and add reputation.
Good day Dear,
it is possible to modify above code to search over a normal range and not over a table?
[value1] = column U
[value2] = column V
[booo no] = column C
have marked as solved and added reputation.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks