LinkBack URL
About LinkBacks
In the sample attached I have a vlookup pulling from a seperate sheet. I have the cells formatted as text so I use the LEFT function to find a value. I keep getting #N/A in spots where I have no idea why. Any help would be great.
In the sample attached I have a vlookup pulling from a seperate sheet. I have the cells formatted as text so I use the LEFT function to find a value. I keep getting #N/A in spots where I have no idea why. Any help would be great.
Hi look into attachment. there is a lack of False in your formula
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Awesome! One problem though, on adding the False to columns F,H, and I's formula, it still resulted in #N/A. Any ideas how to fix that?
The CC numbers in Master sheet are not found in Cost Centre sheet
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
The reason for #N/A in cell G9 is because 627740 is found in cell A2 on the searched sheet.
Your formula is =VLOOKUP(LEFT(Master!$C9,6),'GL Acct. Code'!$A$7:$D$50,4,0)
The searched range starts on row 7 - 5 rows below the match
Same for cell G12's #N/A - the match is in row 5 - 2 rows above the searched range
Adjust the range within the VLOOKUP() to include all rows to be searched
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks