vlookup help, can this be done? (cells J&K filled with G&I data if data in C is a repeat)

[Mike Luce]

ok, I am sure I was doing something stupidly simple wrong.

but I need to get results based on an entered data point.

example in the spreadsheet:
enter data in C16
search column C for the first repeat of data starting at current entry(C16) if found(C9)
pulls data from column G(G9) and enters it in column J of current entry (J16)
then pull data from column I (I9) and enters it in column K of current entry (K16)

[alansidman]

your explanation and your file do not seem to be in sync. I have no idea what you are trying to do. Please refer to the file and explain what the expected results are by giving an example of what you are doing.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Mike Luce]

Does that qualify?

[Mike Luce]

Fixed my original post I was mixing my lime number up with my count number. Thank you

[AliGW]

Thanks for updating the title and requirement.

[Mike Luce]

am I still under Moderator review or are people just not posting to my post? I am asking so I know whether to move on and find a different way to achieve my end results?

[AliGW]

No, you are not under moderator review. You probably need to explain more clearly what you are trying to achieve.