Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup problem
I have an excel file with Overall Hotel bookings in it on the first worksheet. Here the rows are in order of arrival date and have the agency name, reference number, hotel name, group name, number of PAX amongst other things. I want to also have a sheet for each hotel, by looking up the hotel's name in the first sheet and copying the information across. I have tried with vlookup, but all I get is a repeated list of one booking per hotel instead of all the different bookings. Can anyone help ? Thanks in advance -- jamesjohn ------------------------------------------------------------------------ jamesjohn's Profile: http://www.excelforum.com/member.php...fo&userid=9692 View this thread: http://www.excelforum.com/showthread...hreadid=482263 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Range Lookup - Problem | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions |