I'm trying to go through and pull some data from a particular worksheet based off of an "id" column, that unfortunately isn't in the first column in the range of data

In the past when doing similar functions, I've always used VLOOKUP() and then chose the data based off of the column offset (ie, Data1, Data2). However, in this case, I not only need to use Data1 and Data2, I need to be able to get the data in Name which is to the left of the index column. This makes my VLOOKUP fail.

It would be a piece of cake if 'id' were the foremost column (or if the vlookup column offset could be 0 or -1), but unfortunately the data will not be presented to me in that way.

Name	id	Data1	Data2
Apple	1	15	120
Banana	2	15	120
Cherry	3	20	120
Pear	4	20	208
Peach	5	30	208

2/18/2008 1:21:11 PM

Why not just add a column to the right that links to the "Name" column on the left?

[Edited on February 18, 2008 at 1:56 PM. Reason : d]

2/18/2008 1:56:18 PM

That's exactly what qntmfred suggested in the chatterbox. I didn't even think of that

Essentially, I have multiple sets of id/Data1/Data2, but only one Name column far to the left. I added a column on the very right to mirror Name, and then did the offset accordingly. I'm happy now

I was making it far more complicated than I needed to...

2/18/2008 2:02:37 PM

I do the same thing - in a weird way - it's easier to make it complicated

2/18/2008 2:10:28 PM

just got dat Excel '07.... its the shit

2/19/2008 1:35:53 AM