Populate cells based on certain fields data input

[darko1515s]

Hello community.
I have an excel file with to tabs.
In the first tab it will be a database with information.
In the second tab I will have a report sheet that will need to collect data from the first tab based on the report nr entered.

Example:
In the 2nd screenshot in red ( the report sheet), if I type the report nr 1212, I want yellow fields to be populated with data corresponding to the report nr 1212 from the fist tab(the database) row 5, that corresponds to 1212.

If I type 1276 in the 2nd tab ( the report file) certain fileds to be populated with data corresponding row 6 from tab one - 1276

I have a file that does that, but can not replicate the formula.

 

[myall_blues]

For field Data you can use:

=XLOOKUP(I8,'Database sheet'!W5:W100,'Database sheet'!X5:X100)

For field Indicativ proba, use:

=XLOOKUP(I8,'Database sheet'!W5:W100,'Database sheet'!C5:C100)

For field Data esantionarii, use:

=XLOOKUP(I8,'Database sheet'!W5:W100,'Database sheet'!B5:B100)

In each case change 'Database sheet' to the name of the sheet that your database is called, and change 100 to a bottom row appropriate for your data.

 

[darko1515s]

For field Data you can use:

=XLOOKUP(I8,'Database sheet'!W5:W100,'Database sheet'!X5:X100)

For field Indicativ proba, use:

=XLOOKUP(I8,'Database sheet'!W5:W100,'Database sheet'!C5:C100)

For field Data esantionarii, use:

=XLOOKUP(I8,'Database sheet'!W5:W100,'Database sheet'!B5:B100)

In each case change 'Database sheet' to the name of the sheet that your database is called, and change 100 to a bottom row appropriate for your data.

It doesn't seem to work. Any ideea?

 

[myall_blues]

Two things:

• Click in cell I8 and see what it says in the formula bar
• In another cell (say T8) enter =ISNUMBER(I8) and see if it returns TRUE or FALSE

 

[darko1515s]

Two things:

• Click in cell I8 and see what it says in the formula bar
• In another cell (say T8) enter =ISNUMBER(I8) and see if it returns TRUE or FALSE

- By clicking I8 in the formula bar it shows value entered, in my case 1212
- for the 2nd point it returns FALSE

 

[myall_blues]

Try changing formulas to:

=XLOOKUP(VALUE(I8),'Database sheet'!W5:W100,'Database sheet'!X5:X100)

and others similarly.

 

[darko1515s]

Try changing formulas to:

=XLOOKUP(VALUE(I8),'Database sheet'!W5:W100,'Database sheet'!X5:X100)

and others similarly.

For some reason the I8 cell wasn't reporting as number , but after formating the cell the formula works.
Thank for you're help. I am now creating the database and will help me a lot with repetitive tasks.

 

[myall_blues]

You’re welcome. Thanks for the feedback.