A aminali New Member Jun 10, 2010 #1 my data base includes similar field with diffrent values ofr eg: lunch 15:00 sign in 15:156 tea 15:30 sign off lunch 15:45 i want to lookup both the values aginst lunch...help me
my data base includes similar field with diffrent values ofr eg: lunch 15:00 sign in 15:156 tea 15:30 sign off lunch 15:45 i want to lookup both the values aginst lunch...help me
L lavkeshbhatia New Member Jun 10, 2010 #2 Try this formula approach http://rapidshare.com/files/397531243/Repeat_nos_lookup.xlsx It does not use vlookup. The second third fourth etc value are classified in a table another approach would be to use a pivot table
Try this formula approach http://rapidshare.com/files/397531243/Repeat_nos_lookup.xlsx It does not use vlookup. The second third fourth etc value are classified in a table another approach would be to use a pivot table