Matching data across two worksheets

[Jean]

I have two work books derived from an accounting package -
WIP and GP. Data in column B of WIP is from same
derivation as data in column A of GP. Where the data in
column A of GP equals that in column B of WIP (they are
not necessarily in same row on each) I want to return
data in column E of WIP to Column F on GP. Any ideas?

 

[Govind]

Hi,

Try using vlookup function.For eg, if you want to return
column E in WIP, use this formula

=VLOOKUP(A1,WIP!B:E,4,FALSE)

Where A1 is where you have the data from GP which
corresponds to column B of WIP.

Regards

Govind

 

[jean]

Hi

Thanks. That worked for rows where there was a match.
If there wasn't a corresponding match, then N/A was
returned and the total cell also says N/A. I'd rather it
was 0, or remained blank. Tried changing FALSE to 0, but
that had no effect. Any changes to the formula which
would sort this.

Jean

 

[Ragdyer]

Try this:

=IF(ISNA(MATCH(A1,WIP!B:B,0)),0,VLOOKUP(A1,WIP!B:E,4,0)

 

[Jean]

Many thanks. That worked! Been pulling my hair out
trying variations on that theme!

J

 

[RagDyer]

Thanks for the feed bck.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Many thanks. That worked! Been pulling my hair out
trying variations on that theme!

J