| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying a name in a cell reference
Ah, VLOOKUP that worked. Thanks very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
