Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi. I'm having problems trying to lookup data in another worksheet. This issue is that I have a databse with two columns of information in which the information needs to match in order to return the nmber shown in the third column. Here's an example to clarify: Col 1 Col 2 Col 3 Apples 21 A Pears 11 D Apples 2 T Oranges 21 G Pears 2 E If my conditions are "Apples" and "21" how can I obtain the end result of "A" in column 3?? Keith -- Trademark ------------------------------------------------------------------------ Trademark's Profile: http://www.excelforum.com/member.php...o&userid=27790 View this thread: http://www.excelforum.com/showthread...hreadid=472971 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |