Retrieving a values from one worksheet based on value sin another

[matpj]

I have two worksheets.

Worksheet one contains a column called ProjectNo.
Worksheet 2 contains ProjectNo and Release.

I need to insert a column in worksheet 1, and use some sort of function to drag the contents of the RELEASE column (workseet2) where the ProjectNo's (in both worksheets) are equal.

does this make sense?
is it possible?




Matt
London (UK)

 

[KenWright]

Try VLOOKUP.

Hit the FAQ button at the top of your page and see my thread 'How Does VLOOKUP work'

Whilst your there, notice lot sof other FAQS that are also worth perusing in quiet time.

Shout back if you need any help with what you are doing after reading that.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[matpj]

Thanks Ken,
thats great.
Is it possible to embed the VLOOKUP in another formula that will display a specified string, if the returnvalue from the VLOOKUP is #N/A?



Matt
London (UK)

 

[dhulbert]

matpj

something along the lines of

=if(iserror(VLOOKUP("a",A:D,4)),0,VLOOKUP("a",A:D,4))

would sort out your n/a issue.

 

[matpj]

thanks for that.
it works well.
I substituted the 0 for a message to be displayed.



Matt
London (UK)

 

[KenWright]

Generally better to use ISNA rather than ISERROR though. ISNA is very specific and will catch just the instance you have cited, but ISERROR will catch ANY error, and that likely isn't what you want, as it could be hiding an aissue you need to get sorted.

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------