VLOOKUP issues

**performrad** · 07-16-2010, 07:42 PM

=VLOOKUP(G44,KS!$A$1:$D$26668,3,FALSE)

I'm using that formula in cell F44 of worksheet1. On worksheet KS There are 26000 part numbers in column A, and in Column C (3) there are the corresponding prices. I have the part number entered in G44 of worksheet1, trying to return the price for that part number, but I get a #N/A error. If I copy the part number and go to the other worksheet and paste it into the find box, the part number line comes up with the price, etc. So the part number is correct and on the reference worksheet, but its not returning in the vlookup. Any ideas why this may be?

Thanks in advance!

**davesexcel** · 07-16-2010, 07:45 PM

Different format types are my first guess, could you supply an abbreviated example of the workbook?

**performrad** · 07-16-2010, 07:47 PM

Yeah, let me get one together. The KS worksheet I copied and pasted the data from an access database.

**performrad** · 07-16-2010, 07:56 PM

I figured it out putting together the example. I was using the formula without the absolute references. On a related note, how would I set up an IF formula to VLOOKUP the value in H44 if G44 returned a #N/A result?

**davesexcel** · 07-16-2010, 08:03 PM

=if(iserror(
Check it out
http://www.exceltip.com/st/Preventin...Found/810.html

**performrad** · 07-19-2010, 11:44 AM

Originally Posted by davesexcel

=if(iserror(
Check it out
http://www.exceltip.com/st/Preventin...Found/810.html

Thank you. I read it and am trying this formula.

=IF(ISNA(VLOOKUP(G19,KS!$A$1:$D$26668,3,FALSE)),"VLOOKUP(H19,KS!$A$1:$D$26668,3,FALSE))",VLOOKUP(G19,KS!$A$1:$D$26668,3,FALSE))

When I use this formula, if there is no value in the G column, it simply puts the formula to vlookup the h column in as text in the cell. Is there a way I can make it perform the formula instead of just displaying it?