Eliminate creating list that returns blank cells

M

Marc Todd

I am trying to create a new range that returns data from columns of an
existing range without creating a list of blank cells. I used VLOOKUP but
may have used it incorrectly as I changed the seach parameters in each
descending cell in the column. Which function/formula do I use to return
lookup data without creating a list filled with blank cells?
 
G

Gord Dibben

Marc

Use the correct mix of Absolute and Relative references in your VLOOKUP
formulas.

To absolutely fix the table range.....$A$1:$C$50

To absolutely fix the lookup value.....$D$1

Usually the lookup value cell is relative......D1 so it will change.

=VLOOKUP(D1,$A$1:$C$50,2,0) will change to =VLOOKUP(D2,$A$1:$C$50,2,0)

as you copy down.

If I have misread your needs, post back and we can try again.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Hide columns based on row values 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Need formulas for searching for a value in a table and returning row/column name 7
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Vlookup and return sheet name also 2
Publisher is filling blank lines with data 2

Top