I have a ComboBox...that I made from the Forms tool box.

A Forms combo box will return the relative number of the selected item to a
linked cell. You have to correlate that number to the source of the combo
box and then you can use that as a lookup_value.

So, you need to:

Tell us where the source for the combo box is
Link the combo box to a cell
Tell us where 5 columns away is

A combo box doesn't occupy a cell, it "floats" on top of the worksheet. Even
though you may have drawn it "in" cell A1 it does not occupy cell A1. You
can link the combo box to cell A1 and then use cell A1 in a formula to find
the item that corresponds to item number. Then, using that value, find the
item 5 columns away (wherever that is!)

--
Biff
Microsoft Excel MVP


"Minitman" wrote in message
...
Greetings,

I have a ComboBox on a sheet that I made from the Forms tool box.

If I choose an entry from the ComboBox drop down menu, how can a cell
formula use that data to find what is in a cell 5 columns away?

Any help will be most appreciated, thanks.

-Minitman