Vlookup to another sheet and the use of @cell / @row

Linda F

Actually, not working at all.

Andrée Starå

@Linda F

Try this one.

=IFERROR(VLOOKUP(Status@row, {Facilities Request - Project Name}, 4, false), "-")

Linda F

Andree

This didn't work but I think it is because I need to go back to my data collection sheet and clean the data. I am looking at creating a rollup sheet so I can better identify the columns. Then, I believe the formula will work. I may reach out again once I finish setup.

Andrée Starå

@Linda F

Ok.

Let me know how it goes!

Linda F

Well, a few days later and still struggling to reference a sheet in my formula. Below is the formula I am using for the sheet I am looking to reference.

=IFERROR(VLOOKUP([Statement of Work]3, {Facilities Project Summary}, 4, false), "-")

Can you provide assistance?

Mike Wilday

What error are you getting?

Can you also try this without the IF Error?

Can you show us the project summary columns you're pulling from the cross-reference sheet? I'd make sure you are actually selecting four columns that are all together.

Linda F

It's not an error message, but the error is no results. I need data referenced from another sheet.

Mike Wilday

Try this: =VLOOKUP([Statement of Work]3, {Facilities Project Summary}, 4, false)

What does this formula return?

Also, can you share a screenshot of the data you are pulling in the cross-sheet formula?

Linda F

Yes, of course.

Below is the return.

Andrée Starå

@Linda F

Happy to help!

Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots of the other sheet as well? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Linda F

andree@getdone.se

Yes, I placed the link to the summary sheet I created. Most of the data I need will be collected by form or freehand and I will use a project schedule as well to pull in data to the Statement of work sheet. In summary, I will reference data from 2 sheets into the SOW.

Andrée Starå

@Linda F

Where did you put the link?

I'd be happy to take a quick look.

Can you share the sheets/process with me?