ExcelBanter - Linking data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Linking data (https://www.excelbanter.com/excel-programming/348540-linking-data.html)

Roy E[_2_]

Linking data

I am looking to have linked as if I would type a model # on one sheet and it
would find the price of the unit and fill it in. I will have different models
with different prices on a sheet. Would it find the Price any where in a
sheet to go with the type model I type in? Thanks

Jim Thomlinson[_5_]

Linking data

Look at the VLookup formula in help.
--
HTH...

Jim Thomlinson

"Roy E" wrote:

I am looking to have linked as if I would type a model # on one sheet and it
would find the price of the unit and fill it in. I will have different models
with different prices on a sheet. Would it find the Price any where in a
sheet to go with the type model I type in? Thanks

All times are GMT +1. The time now is 07:30 PM.