need function help

  • Thread starter Thread starter txturbo
  • Start date Start date
T

txturbo

Can someone tell me how I can make the Item# cell on an invoice retriev
the description of that item # from another cell on another sheet?
was trying to use the IF function and the VLOOKUP function in the sam
formula
 
Txturbo, assume the Item# is in Sheet1, Cell A13; the table is in Sheet2,
A10:B15, and the description is in column 2 (Column B) of the table. Table
must be sorted in ascending order on Column A.

This will retrieve the Item Description from the table:
=VLOOKUP(A13,Sheet2!$A$10:$B$15,2).
If you name the table, it becomes easier to do the formula:
=VLOOKUP(A13,MyTable,2).

No IF statement is necessary, unless you want to use it to trap an error:
=IF(ISEMPTY(A13),"",VLOOKUP(A13,Sheet2!$A$10:$B$15,2)).
 
The description changes with each item number entered. I wanted to us
=IF(A13>0) with the VLOOKUP function. If this returned a TRUE I wante
to use the item # that was entered in the item# cell(A13) in th
VLOOKUP function to return the associated description for that item#
If it returned FALSE then it remained blank. The formula you gave m
works but it returns the same description no matter what item # i
entered in A13
 
Of course I meant ISBLANK:

=IF(ISBLANK(A13),"",VLOOKUP(A13,Sheet2!$A$10:$B$15,2)).

--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


DDM said:
Txturbo, assume the Item# is in Sheet1, Cell A13; the table is in Sheet2,
A10:B15, and the description is in column 2 (Column B) of the table. Table
must be sorted in ascending order on Column A.

This will retrieve the Item Description from the table:
=VLOOKUP(A13,Sheet2!$A$10:$B$15,2).
If you name the table, it becomes easier to do the formula:
=VLOOKUP(A13,MyTable,2).

No IF statement is necessary, unless you want to use it to trap an error:
=IF(ISEMPTY(A13),"",VLOOKUP(A13,Sheet2!$A$10:$B$15,2)).
Click to expand...
 
Still not working. That still gives me a description even though th
item# cell is empty
 
Txturbo, all I can say at this point is "Well it *should* work, dang it!" If
you want, you can remove sensitive info, send me the file, and I'll look at
it. I'm DDM at DDMComputing dot com.
 
Back
Top