formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a chart, one column asks for the bar size, the other for the pounds
per foot. i want the user to just have to fill in the size, then the pound
per foot will be filled in automatically. here is how the lists go.....

Bar Size pounds per foot
3 .376
4 .668
5 1.043
6 1.502
7 2.044
8 2.670
 
use the vlookup formula

=Vlookup(Barsize,Table,2,False)

where table represents a reference to the table you show. If it were
Sheet2!A2:B7 and in sheet1 you entered a bar size of 4 in cell D9

=if(Sheet1!D9="","",Vlookup(Sheet1!D9,Sheet2!$A$2:$B$7,2,false))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested if statements 7
What formula do I use for this? 1
WCG Stats Sunday 17 October 2021 1
Converting currency to text and spliting to two lines 14
WCG Stats Tuesday 15 December 2020 1
WCG Stats Wednesday 16 December 2020 1
WCG Stats Thursday 10 December 2020 1
WCG Stats Sunday 20 December 2020 1

Back
Top