Call Excel expert

[Nadeem Ahmed Kh]

Mal le meri excel ki sheet me column A ki 1st row X or column B ki bhi 1st row me Y likha hai ya manle ki row no. 2 ke pehle column me "S" or dusre column me "D" hai to jahan khai bhi kisi bhi or row me ye conditions aa jaye to me ye chahata hu ke wahan pe 6 aa jaye ya 10 aa jaye matlab koi bhi numerical value jo me dena chahu aa jaye........Thanks .......demo file bhi attached hai dosto please............

[ShahbazSuper]

i confused of your question.

[skillberry]

i also need to ask how to attach an image in a text row?

[Nadeem Ahmed Kh]

i confused of your question.

Me ye chahata hu ke excel ki sheet me column A or column B me 1st row me manle kuch text likha hai jaise ke manle apple likha hai column A ki 1st row me or mango likha hai column B ki 1st row me ya fir manle ki iska ulta likha hai jaise ke column A me mango or column B me apple to is jasi condition ho to me ye chahata hu ke kuch specific value jaise man le 10 column C ke 1st row me aa jaye iske liye koi formula ho to please bataye??????

[ShahbazSuper]

sorry out of memory,,,,

[syar]

Mal le meri excel ki sheet me column A ki 1st row X or column B ki bhi 1st row me Y likha hai ya manle ki row no. 2 ke pehle column me "S" or dusre column me "D" hai to jahan khai bhi kisi bhi or row me ye conditions aa jaye to me ye chahata hu ke wahan pe 6 aa jaye ya 10 aa jaye matlab koi bhi numerical value jo me dena chahu aa jaye........Thanks .......demo file bhi attached hai dosto please............

Walikum Salam,

as per my understanding

Solution 1:

=LOOKUP(A1&B1,{"ab","ba","xy","yx"},{6,6,10,10})

Solution 2:

=IFERROR(IF(OR(A1&B1="ab"),6,IF(OR(A1&B1="ba"),6,IF(OR(A1&B1="xy"),10,IF(OR(a&B="yx")=10,)))),"")

Change criteria/condition accordingly.

regards

[Nadeem Ahmed Kh]

Walikum Salam,

as per my understanding

Solution 1:

=LOOKUP(A1&B1,{"ab","ba","xy","yx"},{6,6,10,10})

Solution 2:

=IFERROR(IF(OR(A1&B1="ab"),6,IF(OR(A1&B1="ba"),6,IF(OR(A1&B1="xy"),10,IF(OR(a&B="yx")=10,)))),"")

Change criteria/condition accordingly.

regards

Syar Bhai


me shayad glat tarike se swal kr diya hu, pls. find another sheet yhan pe jo D column colored hai wahai pe me esa formula chahata hu ke jaise me - HOME TO ITC joke 65 Km hai, fir ITC to MU joke 6 km hai esi trha se jo bhi distance hai or jahan se jhan tk hai wo D column me likhi hai ab me ye chahata hu ke jhan pe bhi column a or column b wali condition aaye sapose home to itc hai to column d me apne aap 65 km aajaye or isi trah se dusri conitions me sari ki sari distance aa jaye, for example pls find attached file.

[syar]

Syar Bhai


me shayad glat tarike se swal kr diya hu, pls. find another sheet yhan pe jo D column colored hai wahai pe me esa formula chahata hu ke jaise me - HOME TO ITC joke 65 Km hai, fir ITC to MU joke 6 km hai esi trha se jo bhi distance hai or jahan se jhan tk hai wo D column me likhi hai ab me ye chahata hu ke jhan pe bhi column a or column b wali condition aaye sapose home to itc hai to column d me apne aap 65 km aajaye or isi trah se dusri conitions me sari ki sari distance aa jaye, for example pls find attached file.

Excel ka konsa version use kr rahe hain? Oper deye gai formula ko apne mrze k mutabiq adopt kr lain. Srf condition change.ho gi baqi kuch nahee.
Agar aap excel 2013 use kr rahe hain tu phr aap ko apne result k leye kisi function ki zarorat nahee

[Nadeem Ahmed Kh]

Excel ka konsa version use kr rahe hain? Oper deye gai formula ko apne mrze k mutabiq adopt kr lain. Srf condition change.ho gi baqi kuch nahee.
Agar aap excel 2013 use kr rahe hain tu phr aap ko apne result k leye kisi function ki zarorat nahee

nahi ho raha syar sahab ek kr ke bata de or me excel 2010 use kr rahahu, thanks

[syar]

nahi ho raha syar sahab ek kr ke bata de or me excel 2010 use kr rahahu, thanks

AAp apne tamam values ka aik sample table bana lain yani k aap kis kis value k against konse value return chahte hain. Like attached filed. Change ranges/references accordingly.



regards

[Nadeem Ahmed Kh]

AAp apne tamam values ka aik sample table bana lain yani k aap kis kis value k against konse value return chahte hain. Like attached filed. Change ranges/references accordingly.



regards

wah wah wah ho gya thanks brother.......

[Sahil_Jaan]

solved