Product list to match price list

Where is the cell with the dropdown list? Sheet 1 A7
Where is the cell with the formula? Nowhere yet, I want to put the price in C7

What's the sheet name with the table? Sheet 2

What's the address of the table on that sheet? A1-A21 and it is called FIVEGUTTER is the product table and the price table is currently in A42-456 with no name

What formula did you try? if then statement that u posted and Vlookup

I changed sheet 2 so now I hav A1-A21 named as FIVEGUTTER this is the information for the drop down list on Sheet 1 cell A7. I put the corresponding prices on sheet 2 , cells B1-B21 this is named as FIVEPRICE. Now that it is setup like this how do I use the Vlookup u posted earlier. Thanks Scott

In C7:

=if(a7="","",vlookup(a7,'sheet 2'!$a$1:$b$21,2,false))

But is that sheet really named "Sheet 2" (with the space or "Sheet2" without the
space)?

And if there's nothing else on that sheet except the table, I'd use the whole
column:

=if(a7="","",vlookup(a7,'sheet 2'!$a:$b,2,false))



badgrandntl wrote:
>
> I changed sheet 2 so now I hav A1-A21 named as FIVEGUTTER this is the
> information for the drop down list on Sheet 1 cell A7. I put the
> corresponding prices on sheet 2 , cells B1-B21 this is named as
> FIVEPRICE. Now that it is setup like this how do I use the Vlookup u
> posted earlier. Thanks Scott
>
> --
> badgrandntl
> ------------------------------------------------------------------------
> badgrandntl's Profile: http://www.excelforum.com/member.php...o&userid=31035
> View this thread: http://www.excelforum.com/showthread...hreadid=507020

--

Dave Peterson

I got it to work, thanks for your help, I really appreciate it. Scott