Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a text result from 2 lookup columns
Hi,
I'm trying to return a text result based upon a lookup of two columns. For example, if column A = Medium, Column B = High, I'd like to be able to return a result in a third column of MH. How can I go about doing this. Thanks as always, Sam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a text result from 2 lookup columns
Sam,
In C1 try:- =IF(AND(A1="Medium",B1="High"),"MH","") Mike "sam" wrote: Hi, I'm trying to return a text result based upon a lookup of two columns. For example, if column A = Medium, Column B = High, I'd like to be able to return a result in a third column of MH. How can I go about doing this. Thanks as always, Sam |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a text result from 2 lookup columns
Are the results always the first letter of each of A & B
if so: =LEFT(A1,1)& LEFT(B1,1) "sam" wrote: Hi, I'm trying to return a text result based upon a lookup of two columns. For example, if column A = Medium, Column B = High, I'd like to be able to return a result in a third column of MH. How can I go about doing this. Thanks as always, Sam |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a text result from 2 lookup columns
=IF(AND(A1="Medium",B1="High"),"MH","output undefined") might be one option.
=LEFT(A1)&LEFT(B1) might be an alternative approach. You'll have to define what output you want for which inputs. -- David Biddulph "sam" wrote in message ... Hi, I'm trying to return a text result based upon a lookup of two columns. For example, if column A = Medium, Column B = High, I'd like to be able to return a result in a third column of MH. How can I go about doing this. Thanks as always, Sam |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a text result from 2 lookup columns
This is the data I have in G1:J4 (I did not want to have to scroll all the
way to MN to experiment) data a b c x 1 4 7 y 2 5 8 z 3 6 9 In A1 I have the text: y and in B1 the text: b IN C1 this formula =VLOOKUP(A1,G2:J4,MATCH(B1,G1:J1,0),FALSE) returns the value 5 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "sam" wrote in message ... Hi, I'm trying to return a text result based upon a lookup of two columns. For example, if column A = Medium, Column B = High, I'd like to be able to return a result in a third column of MH. How can I go about doing this. Thanks as always, Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup returning incorrect result | Excel Worksheet Functions | |||
Lookup 3 columns and return a result from another column | Excel Discussion (Misc queries) | |||
returning header row as a result... | Excel Worksheet Functions | |||
Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
Returning Forumla For Result | Excel Discussion (Misc queries) |