Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I match two cells and input a value in a different cell?
A B D E
SRM-260 SRM-260 $7.50 SRM-260S SRM-260S $15.00 Ok, I want to input info in column A and have it look up in D and take the value that is in E and put it in B. So if I put in A an SRM-260, I want it to find the SRM-260 in D and input the value in E that matches the SRM-260 into the B which would be the $7.50.However if I input SRM-260S in A I want $15.00 to be in B to math the units. Can anyone help? Thanks, Jason |
#3
|
|||
|
|||
Hi
see: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany pensfan wrote: A B D E SRM-260 SRM-260 $7.50 SRM-260S SRM-260S $15.00 Ok, I want to input info in column A and have it look up in D and take the value that is in E and put it in B. So if I put in A an SRM-260, I want it to find the SRM-260 in D and input the value in E that matches the SRM-260 into the B which would be the $7.50.However if I input SRM-260S in A I want $15.00 to be in B to math the units. Can anyone help? Thanks, Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
making cells adjust | Excel Discussion (Misc queries) | |||
How to verify that 3 cells are equal | Excel Worksheet Functions | |||
blank cells that include text | Excel Worksheet Functions |