VLOOKUP Problem

[xinex21]

Hi, i have a problem with function VLOOKUP
I will try to explain my self,

I have a file where i am the responsable to do a month map with my collegue jobs so i need to in the sheet 'Escala Mensal' put a collegue with a job like on day 30 'A1' like my example to download


on example the collegue nş 438 on day 30 is 'A1' so with VLOOKUP my collegue in sheet '30' is on A1

example to download, regards

[alansidman]

On sheet 30, I don't see a relationship between 438 and A1. Where is it? I see 438 but nothing in the applicable row that would relate to A1. Please clarify.

[xinex21]

On sheet 30, I don't see a relationship between 438 and A1. Where is it? I see 438 but nothing in the applicable row that would relate to A1. Please clarify.

1.png2.png3.png

See images attached pelase hope you hundersant, regards

[Tony Valko]

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

[xinex21]

Thanks for the advises, the file is up to download, but i have difficulty to explain because my language is not english, sorry.

[alansidman]

I still do not understand what you are trying to do. Do you want data placed in Summary Sheet or Daily sheet. Your explanation is not clear on what you are trying to do specifically. Please try to explain to me as if we are sitting in a coffee shop and try to be as specific as possible.

[FDibbins]

I am also having a hard time understanding what you want

Can you walk us through what you are trying to do here (step-by-step), And keep in mind, you know what you are doing, we dont, so please include sheet names and cell refs in your explanation please

[xinex21]

I still do not understand what you are trying to do. Do you want data placed in Summary Sheet or Daily sheet. Your explanation is not clear on what you are trying to do specifically. Please try to explain to me as if we are sitting in a coffee shop and try to be as specific as possible.

The problem is my bad english.

So i just want to work with sheet escala mensal (monthly scale) in this sheet i have a month in this month every day i have to fill the column day with cods (A1 A2 A3 Po1, etc) when i fill tis column take as example the column of day 30, i eant to print the sheet 30 to put in the office so the workes can see what is is time to work (schedule) so when i put the codes in column 30 i want the first column wheres is the number of the workers past to the wright jobs so if i put 438 has A1 on escala mensal sheet he have to go to 30 sheet for the cell who has the formula.
i will left another file to download this file i work with VLOOKUP but i have to hide columns on sheet escala mensal, see please the file that is complete and i will upload now.

If you dont hunderstand i will make a video explaining, thanks