Posted to microsoft.public.excel.worksheet.functions

Max

external usenet poster

Posts: 9,221

NEED EQUATION PLEASE

Maybe something like this

Assume numbers in Sheet1, in A1 down
In Sheet2, place in A1:
=IF(Sheet1!A1="","",VLOOKUP(Sheet1!A1,{400,"James" ;401,"John";402,"Kevin"},2,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Carolan" wrote:
I'd rather do a formula if possible on a different sheet as I will have
several name. For example, 400 = James, 401 - John, 402 = Kevin. So there
could be all three numbers in a column.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if equation	Robert	Excel Worksheet Functions	3	February 3rd 06 09:26 AM
Getting an Equation	kahlua_bundy	Charts and Charting in Excel	3	November 11th 05 01:12 AM
Equation Editor- problem when editing an equation	Gaby L.	Excel Discussion (Misc queries)	0	September 27th 05 09:24 PM
Need help with equation	mkerstei	Excel Discussion (Misc queries)	1	August 4th 05 09:55 PM
Equation	paulo_jorge_34	Excel Discussion (Misc queries)	3	June 14th 05 06:53 PM

All times are GMT +1. The time now is 08:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us