I have a file , I just wnat to search "sheet1" "A" columns from "sheet2" "B" columns :
But it came out the resuit is "VLOOKUP(A1,Sheet2!A: (B) ,2,0)"
Please Login or Register to view this content.
the "B" column (B) have parenthese on it ,it make the formula don't work
do I wirte any thing wrong?
Last edited by am0251; 05-05-2010 at 06:37 AM. Reason: add code tags
Welcome to the Board.
Please add some code tags (around your VBA) at which point we can assist you.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thank you for respond , This is my Excel picture , I thank it can help everybody to unstand more about my question !!
I'm sure the pictures will prove very helpful, however, until such time as you amend your first post and apply CODE tags as previously requested we are not able to assist you (Forum rules dictates as such I'm afraid).
thank you for resopnd shortly, I'am just a beginner of Excel VBA, and I'am a frist time ask question on this forum ,So ..maybe this is a very stupid question : What is the "Code tags" mean?
see Forum Rules - spec. # 3 and specifically the link in the rule itself
Thank you for help , I add the code tags already !
OK - so if you want to use R1C1 style all references in the formula must follow R1C1 notation
Also if you opt to store row numbers in variables use Long and not Integer - the latter does not cater for all possible row numbers.Please Login or Register to view this content.
For a brief (and limited) overview of R1C1 see: http://www.excelforum.com/2171545-post2.html
Last edited by DonkeyOte; 05-05-2010 at 06:47 AM.
Problem solve , Million thank's
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks