Help Please- Copy specific cell value to another sheet if condition met

[paporanjk]

Hi,

I'm new to the forum folks and would appreciate any help.

I'd like to know the formula for automatically populating cell values from column A,B,C on sheet 2 if one of conditions on list from column "N" are met on the sheet 1. I've managed to sort of figure this out by using "IF" formula however sheet 2 has lots of blank rows in between where condition is not met.

Could someone please help?

Many thanks

[FDibbins]

Hi, welcome to the forum

Just so we get the terminology right, I think you want to "pull" info from 1 sheet to another. Formulas cannot do anything to any cell other than the 1 they reside in.

I have a feeling I know what you want, but can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like?To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[paporanjk]

Hi,

Thanks for the prompt response.

I have uploaded the specimen tracker I'm working with as an attachment.

I'd like to transfer the column A, B, c & F from sheet 1 to sheet 2 if column H on sheet 1 reads one of the three below
"Accepted", "Consider", "Compare Elsewhere"

I hope it make sense. Please let me know if you;d like more info.


Thanks

[Pete_UK]

Put this formula in cell I2 of Sheet1:

=IF(ISNA(MATCH(H2,{"accepted","consider","compare elsewhere"},0)),"-",MAX(I$1:I1)+1)

then copy down to the bottom of your data or beyond (to accommodate more data being added. Then, with headings in row 1 of Sheet2, put this formula in A2 of Sheet2:

=IFERROR(INDEX(Sheet1!A:A,MATCH(ROWS($1:1),Sheet1!$I:$I,0)),"")

Copy into B2:C2, and set the format of B2 to General. Then copy A2:C2 down as far as you need to.

Hope this helps.

Pete

[paporanjk]

Pete you the man!!

Thank you very much for you help worked first time. Straight forward and simple!!

[Pete_UK]

Glad to help - thanks for the rep.

Good luck tomorrow night (or are you from the blue half of the city?)

Pete

[paporanjk]

Glad to help - thanks for the rep.

Good luck tomorrow night (or are you from the blue half of the city?)

Pete

RED all the way!! Can’t wait for tomorrow.

Hopefully we could do a repeat of Istanbul! Fingers crossed

[JosieJosie02]

This was awesome!

What if we needed a second filter in sheet 2, we wanted sheet 2 to show only rows for a specific Sheet 1 Column C name. Presumably Sheet 1 Column C would have multiple names.
I have multiple worksheets in a workbook, each sheet would only contain the information for a specific name listed, for example, Sheet 2 Cell A1 had ABC, and sheet 3 Cell a1 had ABC1.

[Pete_UK]

I can see from your post count that you are new to the forum, so Welcome, and please read the Forum Rules (available on the menu at the top of the screen), especially Rule 04 which concerns hijacking of someone else's thread.

You should not do this - instead, you should start a new thread of your own, no matter how similar this thread may seem to your own problem. You can also attach a sample Excel workbook by following the guidelines given in the yellow banner at the top of the screen, and this may help to clarify what you want to achieve.

Hope this helps.

Pete

[JosieJosie02]

I don't see how this is hijacking. I can see you don't want people to get help.
Good luck with promoting a site instead of solutions.

[AliGW]

Thousands of people get help here every year. Our site is heavily used and those who keep coming back again and again for help do so because they know the quality of the assistance they will get AND are willing to abide by our simple rules. If you don't wish to do so (clearly not from your last post), then by all means go elsewhere.

If you want help, then please start a new thread as requested above.