The VLOOKUP formula I'm using returns the formula vs the value when entered into the cell.
=vlookup(I2,Cust_Type!$A$2:$C$23,2,false) Now when I click on the Fx icon in the formula bar it shows a popup with the Function Arguments. It shows the Formula Result = A/C Contractors. This is what I'm looking for but that is not what is appearing in the cell.
Last edited by nander; 06-02-2008 at 04:24 PM.
Hi,
What is appearing in the cell? It may be better to post a zipped sample of your data?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
My problems are in Column J & L
Hi,
The columns are formatted as TEXT, delete your formula's in J2 and L2, then format the columns to General, then enter your formula's again - it should work then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks