repost of question from 2/4 "Using drop-down lists"

[RoofIL]

Thanks for the help.

When I copy and paste the function you provided into C2 on sheet 1 and
press enter I get #N/A.

When I enter this formula and hit enter, a window
title: "Update Values: Sheet 2" pops up. It looks like a "save" or "save as"
window. What do I do there?

Also, I'm not proficient with the formulas in Excel. Can you break down
that formula into what each part means, so I can have a better understanding
going forward? That way I'm not just copying and pasting without actually
learning, so if it doesn't work the way I want, I'll know how to change it.
I'd appreciate it.

Thanks.

 

[RoofIL]

I think I might have it:

I changed 'Sheet2'! to 'DuroLastMembrane'! and hit enter and then chose the
file this workbook is saved as when the screen popped up and then it asked
sheet 1, sheet 2 or sheet 3 and I chose sheet 2.

Did I do this correctly? Seems right to me. When I chose the first choice
in the drop down (40 mil - No Tabs) which was in sheet two A1 with a
corrisponding price of $0.83 in sheet two B1 and entered 1000 for the square
footage into sheet 1 B2, sheet 1 C2 gave me 830.

 

[Shane Devenshire]

Hi,

The easier way would have been to type

=IF(OR(A2="",B2=""),"-",VLOOKUP(A2,
then click on Sheet2 in your workbook and select the column letters A:B then
continue typing:
,2,FALSE)*B2)
and press enter.