Connect/Link cell with name to cell with number

[charan28s]

Hi All

I am looking for a formula or a method to connect name(Person1) in a cell A2 with few numbers in other cell but in same row for eg 10 in A3 and 12 in A4 .Like wise i have Name in B2 and different number in B3 & B4 .How do i connect the names to numbers in same row so that if i move name in Person1 from A2 to D2 the corresponding values from A3 & A4 should transfer over to D3 & D4 ?

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[charan28s]

Actual Sheet.jpgRequired Sheet.jpg

[Richard Buttrey]

Hi,

Either link cells directly e.g. put ='Actual Sheet'!B4 in B2, ...etc
or

use a vlookup formula in B2

=VLOOKUP($A2,'Actual Sheet'!$A$2:$C$4,COLUMN(),FALSE)

and copy to B2:C4

[charan28s]

HI Richard

Tried to make it work but it is not working well for me because the value in cell B2 , C2 needs to be manually input . So if the formula is there sitting it will be hard to connect this to A2 ? Hope you get where i am going ?

[JohnTopley]

Will this work

=IF(A6="","",VLOOKUP($A6,'Actual Sheet'!$A$2:$C$4,COLUMN(),FALSE))

OR

=IFERROR(VLOOKUP($A2,'Actual Sheet'!$A$2:$C$4,COLUMN(),FALSE),"")

[Richard Buttrey]

The formulae go in B2 & C2 on the Results sheet, they refer to B2 & C2 etc on the Actual sheet which are manually input.

Or are you saying that there is only the Actual sheet. In which case follow the same principle but link or change the Vlookup to refer to other cells on the same sheet.

I'm still confused since you are showing the (different) results in the very same cells as the values you start with. i.e. the results have replaced the starting values and I don't see anything in column D to which you referred in your original post.

A step by step explanation of exactly what you do and what you see after each step would perhaps help.

see attached

[charan28s]

HI John

I think i got it working now with Richards formula . Thanks guys for your help