displaying a name in a cell reference
 

I have two worksheets in an Excel workbook.

Sheet1 has a prize designation column with different prizes i.e. WM20, WM10,
etc

Sheet2 has the prize designation (WM20) matched with a name i.e. Walmart
giftcard

I need to display the name from sheet2 in a column on sheet1?

Thanks

displaying a name in a cell reference
 

You could use a vlookup function to do that for you.

Something like this:
=VLOOKUP(B6,Sheet2!$A$1:$B$29,2,FALSE)

Assuming B6 contains €œWM20€�
Assuming the range on sheet2 A1:B29 contains WM20 in column A and the
description €œWalmart 20 buck Gift certificate etc€� in it.

Hope that helps.

Frank


"JimboDB" wrote:

I have two worksheets in an Excel workbook.

Sheet1 has a prize designation column with different prizes i.e. WM20, WM10,
etc

Sheet2 has the prize designation (WM20) matched with a name i.e. Walmart
giftcard

I need to display the name from sheet2 in a column on sheet1?

Thanks

displaying a name in a cell reference
 

Ah, VLOOKUP that worked.

Thanks very much