I want to alias a value in one cell depending on what a vaule is in another cell.
i.e. if cell A1=pineapple; I want cell A2 to automatically read "313"
I want to alias a value in one cell depending on what a vaule is in another cell.
i.e. if cell A1=pineapple; I want cell A2 to automatically read "313"
You need a lookup table & VLOOKUP or LOOKUP
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks