Update cell value based on another cell value

[bryanxchoo]

Hello,
Been trying hard to create the formula for my excel spreadsheet.

Example:
Sheet1
-------------------
A1 value is John
A2 value is Peter
A3 value is Ali
A4 value is Mary

B1 value is 1
B2 value is 0
B3 value is 3
B4 value is 1

Sheet2
-----------------------
A1 value is John
A2 value is Ali
A3 value is Ali
A4 value is Ali
A5 value is Mary

New sheet with value based on B1:B4 value

Is this possible with without VBA, only formula?

Thanks

 

[steve the fish]

You need vlookup. Loads and loads of examples to try to understand its use. If you get stuck come back.

 

[bryanxchoo]

You need vlookup. Loads and loads of examples to try to understand its use. If you get stuck come back.

I tried vlookup but it doesn't serve what I need.

John have 1 so sheet2 will have 1 cell with his name.
Ali have 3 so sheet2 will have 3 cell with his name below john
Mary have 1 so sheet2 will have 1 cell with her name

Thanks for replying.

 

[drp92]

Hello @bryanxchoo
If you can elaborate more on this, meaning if u can post sample data in table form here (like this)

<tbody></tbody>

DATA	dates/particulars
PPQ	8	0
NPR	16	8
STP	24	24
QSF	0	0
PPM	98	24

<colgroup><col span="3"></colgroup><tbody>
</tbody>

and what you want after the formula is built up (in sample-of course), me or someone can help !!

Thanks !

 

[bryanxchoo]

Hello @bryanxchoo
If you can elaborate more on this, meaning if u can post sample data in table form here (like this)

DATA	dates/particulars
PPQ	8	0
NPR	16	8
STP	24	24
QSF	0	0
PPM	98	24

<tbody>
</tbody>

and what you want after the formula is built up (in sample-of course), me or someone can help !!

Thanks !

Here is the table

Name	Number of sale
John	1
Peter	0
Ali	3
Mary	1

<tbody>
</tbody>

Another sheet will appeared this

John

Ali

Ali

Ali

Mary

<tbody>
</tbody>

John will have 1 row, Ali will have 3 and mary have 1, based on the first table.

Hope everything clear.

Thanks