The following formula does not produce a correct result as in cells n:30 to O200 there are concatenated strings. However if I type over the concatenation the below formula will work.
IF(ISERROR(VLOOKUP($D$4&B6,'Money Market'!$N$30:$O$200,2,FALSE)),0,VLOOKUP($D$4&B6,'Money Market'!$N$30:$O$149,2,FALSE))
Does anybody please know how I can incoporate concatenation to make VLOOKUP work correctly or is there any other formula I should use please?
Is there any extra spaces in D4 and or B6 ??
Post a sample file and someone will take a look
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
If I type 1000AUD into cell N30 sheet 2 then formula cell C6 sheet 1 will work. But if I leave as is with concatenation then formula cell C6 sheet 1 will not work. Would welcome any ideas please?
Can you see the attachment
Change this formula
to=MID(A22,7,4)
and drag down=MID(A22,7,3)
As AUD is only 3 characters long your formula was bringing an extra space hence the vlookup couldn't find a match
VBA Noob
That worked perfectly. Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks