software

I have a shee1 like this
A B C
D
ID sub-id grp_id
value
7263081006308_30072 -103686.5016
7263081006308_30072 103686.5016
7363081006308_30073 -103686.5016
7363081006308_30073 103686.5016
5033381013338_30950 -2084777.338
5133391013339_30951 -622559.5433

in another sheet I have data like this
A B C D E
F
Date trade sub-id cval grp_id
2/20/06 72 6308 102726.22391006308_30072
2/20/06 73 6308 -102726.22391006308_30073
2/20/06 50 3338 01013338_30950
2/20/06 51 3339 01013339_30951
2/20/06 74 4532 -13688891.941014532_30074
2/20/06 75 4533 1555032.9031014533_30075

I want to fill the column F with value from sheet 1 based on grp_id.
How can i do that

Vlookup should work you just have to be sure that the array you are
pulling the data from starts with the grp-id column or column C. If
your Vlookup was referring to column A as the first column, that is
where it is looking for the grp id which it is not located in so you
get the NA error.

Try it like this in column F.

=VLOOKUP(E1,LookupSheetC16,2,FALSE)

If it is not there, the VLOOKUP will return an NA error also.

Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=515509but vlookup wont look to the LEFT of grp id you will have to use index/match
for that
--
paul
remove nospam for email addy!
quot;SteveGquot; wrote:

gt;
gt; Vlookup should work you just have to be sure that the array you are
gt; pulling the data from starts with the grp-id column or column C. If
gt; your Vlookup was referring to column A as the first column, that is
gt; where it is looking for the grp id which it is not located in so you
gt; get the NA error.
gt;
gt; Try it like this in column F.
gt;
gt; =VLOOKUP(E1,LookupSheetC16,2,FALSE)
gt;
gt; If it is not there, the VLOOKUP will return an NA error also.
gt;
gt; Does that help?
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=515509
gt;
gt;


True. VLOOKUP will not look to the left but given the example in the
OP, the value is to the right of the grpID. The other option would be
to use the ID field for the lookup if the ID's are unique to the grpIDs
which it appears they are in the sample data.

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=515509