Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement: cell referencing
Hello, I'm using Excel 2003 and need help on an If statement or not sure
whether I should use a Vlook Up table. I have 2 spreadsheets. The first has a list of housing benefit codes e.g. HB0001 in column A. The next column along has the nominal values of what these codes represent e.g. £17.50. In the 2nd spreadsheet I then manually enter each code that the recipient is entitled to in a column. I want to create a IF statement on another spreadsheet that will automatically fill in the nominal value that the code represents. FOr example, I want Excel to look at the column that has all the codes that I enter and then place the nominal value in it's place. Example: Codes: Nominal Value: HB0001 £17.50 HB0002 £21.50 HB0003 £24.50 -- Kind regards Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell referencing | Excel Worksheet Functions | |||
Cell Referencing | Excel Discussion (Misc queries) | |||
Referencing Cell Next To Today's Date Cell | Excel Discussion (Misc queries) | |||
Referencing last cell | Excel Worksheet Functions | |||
referencing cells including an IF statement??? | Excel Worksheet Functions |