Lookup value from either of 2 columns and return value in column 3 all on 1 row

[DylanM]

Hi,

I want to do the following,

I have in column 1 the generic name of a medication, in column 2 I have the brand name. In column 3 I have the side effects of the medication.

From a seperate sheet I want to be able to type either the generic or brand name in to get the side effect information to display in the adjacent cell.

Thank you in advance.

[JohnTopley]

Is the generic or brand name in the same cell on second sheet?

[Tony Valko]

Sounds like you want to do a VLOOKUP.

See this...

http://contextures.com/xlFunctions02.html

[DylanM]

Hey,

I want to be able to enter the generic or brand name into the same cell and from that cell look up an array on a different sheet that has in column 1 the generic name column 2 the brand name and return the side effect info from column 3 to the cell next to the cell I entered the search data on the origional sheet.

Cheers

[JohnTopley]

Assuming "search" value is in A2 of Sheet2

in B2

=IFERROR(VLOOKUP($A2,Sheet1!$A$2:$C$200,3,0),VLOOKUP($A2,Sheet1!$B$2:$C$200,2,0))

to get value of Side effects

[DylanM]

Cheers thank you very much