Microsoft Office Forums - View Single Post - [Solved] If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)

Thread: [Solved] If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)

View Single Post

Old

10-21-2014, 06:26 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

If there is only one watch to look for, sure:

B10: =VLOOKUP(A10,C2:C20,2,FALSE)
C10: =VLOOKUP(A10,C2:C20,3,FALSE)

Reply With Quote