New to this

[kayth891]

I’m trying to link the square footage on the Taxes worksheet to the lot number (G8 on sheet1). That way, when I enter the lot number on G8 it automatically pulls the corresponding square footage into the calculation on the taxes sheet and puts the result in cell G41 on Sheet 1.





Thanks!!!

 

[Peter_SSs]

Welcome to the MrExcel board!

For somebody to be able to help I think they will need to know a bit more about your data and layout. A small set of dummy data and expected results, with any further explanation given specifically in relation to that sample would help.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are, without heaps of typing. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[GazNicki]

I would use a LOOKUP for this.

But Peter is very right, much more information is needed. How is the "Taxes" sheet formatted for example?