Vlookup problem

[19Felipe85]

Hi guys,

I am sorry for probably posting a problem that most of you find easy but what can i say, im not that good with excel - though im learning!

In worksheet one I have a bunch of numbers in E2:E88 with a corresponding name in F2:F88.

In the second worksheet I want to type in a number in cell B4 and get the corresponding name in cell C4.

I thought I had to use the Vlookup-function but I get this #ref-error every time. Is this the wrong formula and should I use a if-then function?

I hope someone can help. Thank you!

Felipe

 

[VoG]

Hi. In C4

=VLOOKUP(B4,Sheet1!E2:F88,2,FALSE)

 

[19Felipe85]

thanks! that's what i really was searching for!

now, if i drag the function down it says #N/A function so i thought to use the isna function:

=if(isna(VLOOKUP(B5;Invulsheet!E$2:F$88;2;FALSE)),"",VLOOKUP(B5;Invulsheet!E$2:F$88;2;FALSE))

but it gives an error

what is wrong?

 

[VoG]

What error? This works for me

=IF(ISNA(VLOOKUP(B4,Sheet1!E$2:F$88,2,FALSE)),"",VLOOKUP(B4,Sheet1!E$2:F$88,2,FALSE))

 

[19Felipe85]

cell C4 in my sheet contains

=IF(ISNA(VLOOKUP(x,x,x,FALSE)),0,VLOOKUP(x,x,x,FALSE))

when I press enter it says the formula you typed contains an error..

and when I press enter again, it highlights the 0 and second VLOOKUP

 

[scottylad2]

Enclose x,x,x, in quotes. "x,x,x," the commas are throwing excel off, they will be ignored if you enclose in quotes.

 

[melewie]

"x,x,x" in stead of x,x,x

That should then work

Edit: **** I was beaten to it!

 

[19Felipe85]

Lol!

Thanks guys! That was really all I needed!