VLookup

[DEllis]

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?

 

[DEllis]

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:

=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.

Hi Joe4, I got it to work! Thank you and Fluff for your help on this question.

 

[Joe4]

Hi Joe4, I got it to work! Thank you and Fluff for your help on this question.

Glad to hear it!

What was the issue? Did you have the wrong cell reference in the first argument of the VLOOKUP formula initially?