VLookup

DEllis

Active Member
Joined
Jun 4, 2009
Messages
344
Office Version
  1. 365
Platform
  1. Windows
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet B and then enter the value that is in column 31 back on sheet A in field J5. If there is no value, I would like it blank. Can you help me please?
 
If I put 28 instead of 29, I get the data from the column before, but it is not pulling in the 8 or any column after...so weird. I cannot post the data as it is very sensitive.
Just "dummy up" the data (removing any sensitive informnation) and post that.

It sounds to me like you really do not have data in column AE in that matching row.
Do you happen to have any merged cells in your data?
 
Upvote 0

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Just "dummy up" the data (removing any sensitive informnation) and post that.

It sounds to me like you really do not have data in column AE in that matching row.
Do you happen to have any merged cells in your data?
I have a dummied up spreadsheet, but due to security reasons I cannot download the tool. How else can I get the spreadsheet to you?
 
Upvote 0
Did you try my suggestion?
 
Upvote 0
Can you answer this question I asked?
Do you happen to have any merged cells in your data?

I have a dummied up spreadsheet, but due to security reasons I cannot download the tool. How else can I get the spreadsheet to you?
Can you at least take a screen grab/image and post it?
I have used the Snipping Tool that comes with Office to do this before.
 
Upvote 0
Can you answer this question I asked?



Can you at least take a screen grab/image and post it?
I have used the Snipping Tool that comes with Office to do this before.
Hi Joe4, there are no merged cells that I am aware of. I have taken two screen shots of the sheets.
 

Attachments

  • Sheet A Pic.png
    Sheet A Pic.png
    5.1 KB · Views: 3
  • Sheet B Pic.png
    Sheet B Pic.png
    19 KB · Views: 3
Upvote 0
Hi Fluff, yes and that gave me a #name error.
That suggest you don't have the latest updates.

If you change Joe's formula to 28 does it return Deb?
 
Upvote 0
That suggest you don't have the latest updates.

If you change Joe's formula to 28 does it return Deb?
Yes, it does but it doesn't return what is in 29 or 30 or 31.
 
Upvote 0
What exactly is in col AE is it a hard value, or a formula?
 
Upvote 0
Did you copy/paste my formula exactly as-is, or did you try to type it yourself?
If you tried to type it yourself, check for typos, especially in your lookup range (the second argument of VLOOKUP).
Make sure the sheet name matches EXACTLY what you have, and it is going all the way out to column AE.

I set up the example you posted, and this formula returned 8 for me:
Excel Formula:
=IFERROR(VLOOKUP(N2,SheetB!C:AE,29,0),"")
Note the only change from my original formula was changing N5 to N2, as you have "Spark" in N2 in your posted example.
 
Upvote 0
Solution

Forum statistics

Threads
1,212,927
Messages
6,110,733
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top