LOOKUP to return values from multiple columns

**jeffreybrown** · 05-31-2017, 10:36 AM

Hello Mike & Welcome to the Forum,

Take a look at this

The key with the Vlookup is the third argument. Adjust for the column you want to return.

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

**Just Mike** · 05-31-2017, 12:09 PM

I understand but I need to return more than just a column/cell value. I want to look up another spreadsheet based on my text entered in a cell.
Then in the next cell reference said spreadsheet and drill down to a particular part number that I am now typing and autofill the next 2 columns.
(All in the same row). I read thru the link you posted but I don't think it addresses my exact need.

Thanks for your help!

LOOKUP to return values from multiple columns

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Newbie Here-Need help with VLOOKUP (I think)

Re: LOOKUP to return values from multiple columns

Thread Information

Users Browsing this Thread

Similar Threads

Lookup multiple values in different columns and return a single value

lookup multiple columns and return values as concatenated

VBA code to compare multiple columns on two tabs and return matching values - Lookup

lookup multiple values in multiple columns to return a result

[SOLVED] Lookup match index multiple values return other columns

Lookup multiple values in multiple columns and return value

Lookup in Multiple Columns, Return Multiple Values

Bookmarks

Bookmarks

Posting Permissions