------ Register to get rid of these "In Post" ads! ------


Is it possible to use a formula referenced by a cell as the range area within
Vlookup?

I am trying to do the following vlookup -

vlookup(j51,+p51,2)
j51 is a valid receipt number I am trying to look up for an invenotry item.

+p51 is a formula of other vlookup concatenated together to form a range
value -
it looks like AE$4:AH$30 done by the formula
=+"AE$"&+VLOOKUP(C51,B$8:G$22,5)&+":"&+("AH$"&+VLOOKUP(C51,B$8:G$22,6)) This
define the specific area of a particular inventory item and where all the
recepits. Each item has a different area and no set row amount.

For exxample Item ABC will be in rows 4-30 whereas CDE would be in rows
31-91. The receipts nuumber will alwats be in column AE of the receipt table
but the receipt # repeat for different items. Meaning Receipts #123 is in
both ABC & CDE.Which is why I was defining the item area first, then focusing
on receipt number.

2 is the column number in the rea of AE - AH.

The purpose of this lookup is to bring in a receipt # date so I can comppare
it against a sold date to find out how long an item stood arond in stock.

Is this possible or is there a better way to do this?

Thank you in advance for any help.

Bruce