H-LOOKUP/v-LOOKUP

[JimmyZ_1977]

Hello guys,

I have created a tracking spreadsheet for inventory rentals, and it worked perfectly when i had the VLOOKUP and the unit numbers going horizontally down. However bosses wanted me to do the unit numbers for each rental lease going vertically. I cannot get either to work for more than one line because i think that the parameters state it pulls from the upper left most colum. Mine has 50 spaces for the unit numbers. is there a way to have it search for values that don't necessarily have to be pulled from the top left?? I can include an example if necessary

[JimmyZ_1977]

Here is the example I forgot to include on my first post.

[daddylonglegs]

Hello Jimmy,

You posted this in an "Outlook" forum - I've moved it to "Excel General"

[JimmyZ_1977]

Thanks I should have caught that