Returning Muliple Cells Values (Excel 2003)

Topic

New Reply

I have worksheet A with 5 columns of information and 10 rows.
I have worksheet B with just one column of information and multiple rows.
Column A in both worksheets are codes.
I want to do a function that will look at col A, find the match to it on
worksheet B and then return columns B-G on the same line that it matched
column A on.

I know this sounds fuzzy but I can return one value (i.e. column B2, but not
columns b2 through 6g

Thanks, francis

Reply | Quote

Replies

If I understand you correctly, you can try the userdefined functions I created in post 395,235. I think VLindex should work for you.

Steve

Reply | Quote