Using variables in cell numbers--ACK!

[Daryle]

Here is the scenario:

I have a Combo Box control on worksheet CONFIG that lists
part numbers from Worksheet DATA. Selecting one of the
combo box choices sets the value of it's linked cell to a
numerical value (1-160). In Column PART NUMBER on Wksht
CONFIG I need to return a part number from wkst DATA,
based on the choice from the combo box. One, long,
cumbersome way to do this would be with a giant IF
statement. I do not want to go that route. My other
option and crux of my question is to return a value from
wkst DATA, Column PART NUMBERS (A) and Row #-(variable
based on the linked cell value on Worksheet CONFIG. Can
that be done, how, and am I making sense??

D

 

[acw]

Daryle

Have a look at the LOOKUP, VLOOKUP and HLOOKUP functions
depending on how your data is structured in sheet DATA.


Tony

 

[Leo Heuser]

Daryle

I'm not sure, I have understood you correctly.
Will this formula do?
Assuming Partnumbers in A2:A1000 on sheet Data
and the linked cell on sheet Config in cell D2

=INDEX(Data!A2:A1000, D2)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.