Guys:
I have to create a vlookup for a range of cells. I have included an example below.
Here is my problem. How do I account for the formula when I do not know how many rows there will be in my range?
I already created a variable to store my row count, not sure on the rest.
Example: here is my current lookup formula that I created manually. ( obviously I know the range): =VLOOKUP(AE2,$AC$2:$AD$64828,2,FALSE
I copied my data into the same sheet so I can count the rows and store it into a variable. I just need help with using variable in my lookup formula; or is there an easier way?
Example data:
<tbody>
</tbody>
Thank you,
Rocco
I have to create a vlookup for a range of cells. I have included an example below.
Here is my problem. How do I account for the formula when I do not know how many rows there will be in my range?
I already created a variable to store my row count, not sure on the rest.
Example: here is my current lookup formula that I created manually. ( obviously I know the range): =VLOOKUP(AE2,$AC$2:$AD$64828,2,FALSE
I copied my data into the same sheet so I can count the rows and store it into a variable. I just need help with using variable in my lookup formula; or is there an easier way?
Example data:
RCD:TYPE | RCD:FUNCTION | Create From | Lookup: Function Field |
3C16942A | SWITCH | BLANK-PNL-19INCH-2 | CABINET_SUPPLY |
3C17111 | ETH_SWITCHMODULE | BLANK-PNL-19INCH-2 | CABINET_SUPPLY |
3C17121 | ETH_SWITCHMODULE | BLANK-PNL-19INCH-2 | CABINET_SUPPLY |
3C17131 | ETH_SWITCHMODULE | BLANK-PNL-19INCH-2 | CABINET_SUPPLY |
3C17203 | SWITCH | BLANK-PNL-19INCH-1 | CABINET_SUPPLY |
3C17203 | SWITCH | BLANK-PNL-19INCH-1 | CABINET_SUPPLY |
<tbody>
</tbody>
Thank you,
Rocco