Column Lookup/Recognition

[epair]

Hi all-

Not sure if I'm just over-complicating this in my head... this might be really simple but I just can't figure it out.

I'm trying to make it so that every time a column has the word "Yes" in it, the cell returns the price in the same row as that "Yes."

Capture.PNG

Ideally, I'd be able to add rows without much trouble. If anyone has any ideas, please let me know!

Thanks!

[hoyasaxa215]

A picture isn't very helpful. Can you upload a sanitized sample file? It's not clear where the prices are coming from or how your data are organized.

[epair]

I realize I probably didn't give enough information...

The idea is that each person/column has their own table so that the price is added to their table, once the "Yes" is recognized. Not sure if that helps at all.

[epair]

Money-Owed-to-Me.xlsx

This is what I have so far.

[hoyasaxa215]

Which cells contain the data you'd like to import and which cells do you want the imported data to appear in?

[epair]

The Per Person Price (Column J in the Sessions Sheet) ideally would appear with the person's name in the People Sheet, but only if the Name has a "Yes" under it in the Sessions sheet. I'm sorry if I'm not explaining it well

[hoyasaxa215]

That's how it seems to be structured already. What exactly are you trying to automate?