Hi,
I have created a table with info i need in and called it BusNumber.
the 3rd column along is the amount of seats the bus has on it.
In Cell b7 i input an number, lets say 20 for example, then below that in cells b17 downwards i would like it to come up with a list of busses that have that number of seats and more, with my limited knowledge of spreadsheets as far i was thinking a formula along these lines would work
=If(Vlookup(b7,BusNumber,3,>b7),(vlookup(b7,BusNumber,2)),"")
and if there werent any busses that met the criteria it would remain blank, however this has not worked on my sheet, it says there's an error. I think that this could need a macro but i'm not sure.
I'd be very greatful of any help
Regards Si
I have created a table with info i need in and called it BusNumber.
the 3rd column along is the amount of seats the bus has on it.
In Cell b7 i input an number, lets say 20 for example, then below that in cells b17 downwards i would like it to come up with a list of busses that have that number of seats and more, with my limited knowledge of spreadsheets as far i was thinking a formula along these lines would work
=If(Vlookup(b7,BusNumber,3,>b7),(vlookup(b7,BusNumber,2)),"")
and if there werent any busses that met the criteria it would remain blank, however this has not worked on my sheet, it says there's an error. I think that this could need a macro but i'm not sure.
I'd be very greatful of any help
Regards Si