ExcelBanter - LOOKUP TO RETURN MULTIPLE VALUES

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - LOOKUP TO RETURN MULTIPLE VALUES (https://www.excelbanter.com/excel-discussion-misc-queries/154757-lookup-return-multiple-values.html)

wilma2299

LOOKUP TO RETURN MULTIPLE VALUES

I've been using the following formula with teh cntrl+shift+enter, but
I'm not really sure what it does.

=INDEX(E:F,SMALL(IF(E:E=E2,ROW(E:E)),ROW(1:1)),2)

What I'm trying to get the formula to do, is I have list of 135 user
ID's on one worksheet. I would like to search four other worksheets
and return the values that are in the next column over. Anyone have
any idea?

Sameer Nagi[_2_]

LOOKUP TO RETURN MULTIPLE VALUES

vlookup can be used here.....

"wilma2299" wrote:

I've been using the following formula with teh cntrl+shift+enter, but
I'm not really sure what it does.

=INDEX(E:F,SMALL(IF(E:E=E2,ROW(E:E)),ROW(1:1)),2)

What I'm trying to get the formula to do, is I have list of 135 user
ID's on one worksheet. I would like to search four other worksheets
and return the values that are in the next column over. Anyone have
any idea?

All times are GMT +1. The time now is 02:23 AM.